[D.Ramesh]

Hi!
How to do an export/import in mysql on WIN2000.

Many Thanks,

[pingu8613]

Originally posted by D.Ramesh
Hi!
How to do an export/import in mysql on WIN2000.

Many Thanks,

I usually run LOAD DATA INFILE mto import and mysqldump [OPTIONS] database [tables] to export (see below).

http://www.mysql.com/doc/en/mysqlimport.html
http://www.mysql.com/doc/en/mysqldump.html
/maria

[omiossec]

You can check

http://www.lasso-developpeur.net/us/...tab=db&lang=us

For importing text file in a mysql table

[D.Ramesh]

Thanks!

[D.Ramesh]

Hi!
c:\mysql\bin>mysqldump --all-databases > alldbdump.sql

Using the above command i have taken the dump of all the databases. Now i want to restore all the databases in the dump to a new machine.How to do it?I have to use the Load data Infile or is there any other way.Buy using the load data infile .txt files can be imported to table.

Now i have one dump file(alldbdump.sql)?

Many Thanks!

[omiossec]

MySqldump whithout specifics options
Will produce a simple sql file
contenning db and table creation statement
and insert statement to populate the table

So to restaure your db on an other serveur you should use

mysql -u [user] -p -h [hote] .... < file.sql

[D.Ramesh]

Thanks a lot...