Solved

mySql import syntax needed.

Posted on 2006-11-07
3
340 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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
paypal ipn to mysql 3 78
two ways encryption with php 3 44
restriction of entering a a page 5 32
Get data from two MySQL tables 6 24
All XML, All the Time; More Fun MySQL Tidbits – Dynamically Generate XML via Stored Procedure in MySQL Extensible Markup Language (XML) and database systems, a marriage we are seeing more and more of.  So the topics of parsing and manipulating XM…
I have been using r1soft Continuous Data Protection (http://www.r1soft.com/linux-cdp/) for many years now with the mySQL Addon and wanted to share a trick I have used several times. For those of us that don't have the luxury of using all transact…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

749 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