Solved

mySql import syntax needed.

Posted on 2006-11-07
3
330 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?
0
Comment
Question by:nediam1234
  • 2
3 Comments
 
LVL 35

Accepted Solution

by:
Raynard7 earned 200 total points
Comment Utility
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
0
 
LVL 35

Expert Comment

by:Raynard7
Comment Utility
if you use --databases then you can specify which to download
0
 

Author Comment

by:nediam1234
Comment Utility
Thank you for your answer...  Got everything now :)
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Loading csv or delimited data files to MySQL database is a very common task frequently questioned about and almost every time LOAD DATA INFILE comes to the rescue. Here we will try to understand some of the very common scenarios for loading data …
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now