New here... Backup SQL or export it...

[Anon]

Hi there!

Im a newby here and i dont understand very much of mysql...

How can i export all the stuff from on mysql db to another mysql db?

Its there any program to do that?

How can i do and what i have to do to export my db content to another mysql db in other hosting company...

Please hel me, respond this or email me 🙂

[Anon]

yes take a tools named mysqlfront can duplicate a mysql db to other mysql db

http://www.anse.de/mysqlfront/

[[deleted]]

There is a very nice tool called 'mysqldump' which will dump your database
into a textfile filled with SQL statements that can re-create your tables.

You can use that file with the 'mysql' commandline tool to create your tables anywhere

To make a backup:
mysqldump database --add-drop-table >output.txt

To restore a backup:
mysql database <output.txt

Note: Read the mysql manual about mysqldump and database copying.

READ IT.

Don't start trying things out without reading the manual, or you will destroy all your data.