Solved

mySql import syntax needed.

Posted on 2006-11-07
3
342 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 35

Accepted Solution

by:
Raynard7 earned 200 total points
ID: 17887710
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
ID: 17887720
if you use --databases then you can specify which to download
0
 

Author Comment

by:nediam1234
ID: 17887776
Thank you for your answer...  Got everything now :)
0

Featured Post

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

624 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