Dump mySQL Database

[Brian]

You might want to check out this tutorial:
http://www.aota.net/PHP_and_MySQL/mysqldump.php3

Once you have dumped it you can then open up this file in your favorite text editor.

Let me know if you need additional help.

-Brian
[This message has been edited by Brian (edited 09-28-00@1:02 pm)]

[urban]

If you are transferring the entire database, including the structure, just use mysqldump like so:

mysqldump --opt -uname -ppassword -hhost xdatabase > path_to_file.sql

If you only want to transfer the data, you might use something like:

mysqldump -t -uname -ppassword -hhost xdatabase > path_to_file.sql

To read the data back into a MySQL server:

mysql xdatabase < path_to_file.sql

[flint_6]

Hi

I'm new to mySQL. I come from MSSQL 7 but for many clients the SQL server from MS it's much too expensive. That's why I'm trying to use mySQL.

I wanted to ask how to make a database dump in mySQL into a file. When I develop a database at my studio and then want to transfer it to the companies webserver, what do I have to do?

And how can I read the dumped file in again?

Any help would be appreciated!

Thanks!

Flint_6
[This message has been edited by flint_6 (edited 09-28-00@12:47 pm)]