Note: Updated Dec. 5, 2011 to reflect the latest changes in drush commands.
I backup databases, sometimes several times a week using drush.
$ drush sql-dump --result-file=backup.sql(By the way, using the --result-file option instead of a redirect to prevent corrupting the charset in your data).
However, when reloading a backup I would always use the mysql command directly because drush doesn't have an import command. This means looking up the password and manually typing it in.
$ drush sql-connect mysql -hlocalhost -unathan -psomething some_database $ mysql -hlocalhost -unathan -psomething some_database < backup.sql
I finally figured out how to use drush for loading mysql dump files. From the command line you can convert the output of a command into a command itself, using the following syntax.
$ $(drush sql-connect) < backup.sql
Or, similarly, using the backtick character to wrap the command.
$ `drush sql-connect` < backup.sql
Comments
using drush to load a dumped database backup
Great! ... Except.. what about when you get: :www bronius$ $(drush sql connect) < pp-site.sql -bash: Warning:: command not found :www bronius$
drush sql connect< pp-site.sql -bash: Warning:: command not foundI know drush itself is working just fine, because I used it to create the sql-dump in the first place.
2 possible solutions
Maybe you are using the latest version of Drush and should instead use the hyphenated command:
$(drush sql-connect) < test.sql
The other possibility is that you are using a bash alias to point to the drush script instead of a symlink. I'm not sure, but that might cause the wrapped drush command to fail.
yes, sql-connect not sql connect
Thanks! You're so correct. Using the appropriate sql-connect syntax does the trick.
In case someone doesn't know: Using just
drush sql-connectplaces you in command line mysql in your drupal mysql context, and using drush sql-connect (without backticks) reports back your drupal mysql connection info (db, user, pass) in plain text.Hmm.. inability to connect but password is correct
Have you ever seen this:
drush sql-connect< pp-site.sqlERROR 1045 (28000): Access denied for user '*****'@'localhost' (using password: YES)for an otherwise valid connection string? sql-dump, for instance, works just fine.I suspect it's due to need of escaping a special character in my ultra-secure password. Should I file a drush issue on it?
`drush sql-connect < thesql.sql` works to load db with drush
Just wanted to round back to say thanks again: I use this command about 20 times a day when pushing to staging sometimes. No need to track local vs remote db users/passwords. Also, to answer my own question, indeed the problem was weird characters in the password. I created a new user just for this with a simpler password, and voila, no errors :)
Great to hear
Great to hear and glad this post was helpful.
Drush: Command Not Found
I'm having an issue where I can execute the drush commands without an issue with an SSH connection, but the cron job (same script) cannot find the drush command.
Set PATH
When a script runs from cron it doesn't alway have the same environment variables as when you login via shell. You'll either need to replace "drush" in the script to the full path, like "/usr/local/bin/drush" or set the path at the beginning of the script:
Thanks
It's working now, I knew it would be something simple like the environment or a permission issue.
Thanks!
Great post, simple - concise and easy to translate to newer versions.
Ummm no.
(drush sql-connect) does just that; it connects. But it does not load the database. In fact, what the result is the mysql string that it builds
mysql --database=dbname --host=localhost --user=username --password=password.
That's what the drush command
That's what the drush command does by itself, but if you wrap the command in $() and follow it with a redirect (ie. < file.sql) then you get the desired result of loading the file into your database.
Drush sql-load failing
I wish that was true..
$ (drush sql-connect) < /Applications/MAMP/htdocs/lib/2011-12-05a.sql
Produced: mysql --database=mydb --host=localhost --user=dbuser --password=dbpassword
Remove the space between the
Remove the space between the $ and the first parenthesis.
Thanks for sharing the
Thanks for sharing the command using Drush for loading MySQL files.
Very cool!
That's a really great tip Nathan. Thanks for sharing!
Marc by Marc Jacobs bags
Marc Jacobs Bag romantic being from mother nature herself towards the lovely antelope printing divulges typically the authentic ecology of this genuine natural environment in your bag.Marc by Marc Jacobs Bags, darkness gray dog's fur purses, the actual low-key extravagance not to mention exquisite texture 。Marc by Marc Jacobs Handbags consistently usage smart styles not to mention pleasure not to mention attractive type typically the testing towards you and me.In no way please let a feelings will be swinging all the way up? Marc Jacobs handbags romantic being from mother nature herself towards the eye-catching antelope printing divulges typically the original ecology of this genuine natural environment in your bag.Typically the diverse patterns, Marc Jacobs purses most women stands out!
Coach Outlet is designed so
Coach Outlet is designed so elegance and it is cheap sale Coach Outlet Online. The handbags are one of the most popular designer handbags on the Coach Outlet Online today. Coach Colette Handbags which is one of the classic styles of Coach Outlet. Colorful appearance and beauty accessories are the point of Coach Purses Outlet. These Coach Colette Bags are must-have from this classic Coach family. The traditional stylish Cheap Coach Handbags with gorgeously and luxuriously dotted coach print appearance, updates an Coach Factory extremely clean and extremely modern day time style research to accomplish Coach Outlet Online a alluring stylish coach bags. Every professional woman needs a good handbags. No matter what your industry or position. Colorful appearance and beauty accessories are the point of Coach Colette Bags.Every professional woman needs a good handbags. No matter what your industry or position, a Coach Factory Outlet is essential for anyone to be taken seriously at the condition. Welcome to our website and we will provide the best Coach Colette Handbags and best service for dear customers.
Goyard Bags
Most of us present Goyard Handbags, many your Goyard Bags at discount are usually in top quality level, you could end up assured to express to some others whatever you pay for are classified as the very best.Goyard St Louis a really elegance! when i seemed to be however debating on there as i determined so it prices pretty much $900 ; however , i stumbled upon available the item is included with that very little wallet and so now i am available! At this time, there are numerous items of material around the excellent goyard tote potential buyers with goyard-bags.org.You possibly can select the approaches that you are engaged.Uncover goyard wallet at a large collection connected with on the net store.
True Religion Outlet
As we all know, the http://nikeoutletcheap.com/ end of a single number is not much, so most of them are fake.So how to identify genuine and fake foreign trade last single has become a headache. the original single goodsThe original http://nikeonlines.com/ single shipment of foreign trade in the true sense of the end of a single cargo. All of these commodities with the fabric / accessories http://truereligioncheapoutlete.com/ type version is provided by foreign brands in the domestic manufacturers out of the best equipment and management, these jeans, if the quality is perfect, it http://www.truereligiononlinecheap.com/ will become really expensive goods in the store. However, due to the very strict quality inspection, there is always a small part of the brand declined, and returned, so it was a real sense of the foreign trade last single, these products are often not low quality, a small number, due to defects, usually cut http://truereligiononlinestore.com/ standard by manufacturers generally to the market is three to one-fifth of the price of the genuine.
discount oakley sunglasses
2012 sunmmer is coming,oakley eyewear hot sale on discount oakley sunglasses online,every year cheap oakley is welcome by young people,it wears cool on the summer holiday. http://www.discountoakleyeyewear.com
Mont Blanc Pens
Mont Blanc Pens|
cheap mont blanc|
longchamp handbags|
longchamp wallets|
longchamp sale|
longchamp bags|
longchamp bags on sale|
longchamp outlet|
short uggs cheap,classic uggs
short uggs cheap,classic uggs on sale,sheepskin boots cheapshort uggs cheap,Service quality, 100% quality, our UGG Nightfall Boots is prime quality!Chance knocks but once.These high-ending ugg Nightfall Boots have now been sold at incredible prices.Don't miss them! Detailed here is a effective summary associated with distinct Discount UGG Sandal Sale that will help using your everyday regimen. After you obtain ugg " booties ", you should adhere to the specific contact hue or maybe hue.An easy method brilliant anyone who cares to seems to be having a person, combined with the colorings and in addition contrasts, is definitely influenced by your hue. Tints which are discolored shaded, including beige or maybe lung burning ash, became pertaining to sunnier circumstances, considering that they decrease the specific splendour and good hue distortion. Whenever participating in tips, much lighter ring tones much like greater or maybe good are usually ideal, considering that they help level notion and in addition cloudier place.We accomplish wish there is a fantastic offering together with uggs online.You can buy discount uggs at our ugg australia uk sale online! discount zgg sheepskin boots are common to most using individuals out there.Genuine UGG sheepskin boots could be put on for just about any amount of years.People are that you must match this kind of style clutches with clothing which are brimming with stars being not having enough plushy excellent. An additional level would be that do not forget that precious jewelry are important for everyone to be able to complement these four-legged friend design totes. Big Ugg Boots Sale and fashioned seem to be straightforward element of people rings.Thats how good the product happens when you invest, you needn't bother the price of the merchandise but what are important would be the quality and the benefit you'll have. Think about remember, invest in the product that you know it provides you with comfort and very much worthy for the investment.ugg boots sale uk became famous because surfers from Australia used it as one of their protection. Now these Aussie surfers, travelers the world and later on introduce to the public concerning the UGG boots
Post new comment