We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

mySql import syntax needed.

nediam1234
nediam1234 asked
on
Medium Priority
387 Views
Last Modified: 2012-08-13
I have a dump file created with:

mysqldump --allow-keywords --opt -uroot -p<mypassword> --all-databases > everything_mysql.sql

Is it possible to list what databases are in the dump file and import just some of them to a new server, or do I have to import everything that's in the dump file to the new server? if it's possible to import just some of the databases in the dump file... what is the syntax? and also what is the syntax if I can only import everything?
And if the export was done in MySQL 4.1 is there any problem importing it into version 5?
The MySQL which the dump file is taken from is from Windows XP machine, will there be any problem importing the dump file into linux MySQL?
Comment
Watch Question

Top Expert 2006
Commented:
Hi,

For the compatibility there should not be a problem. (forward and also cross OS)

shell> mysqldump [options] db_name [tables]
shell> mysqldump [options] --databases db_name1 [db_name2 db_name3...]
shell> mysqldump [options] --all-databases

http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Top Expert 2006

Commented:
if you use --databases then you can specify which to download

Author

Commented:
Thank you for your answer...  Got everything now :)
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.