Page 1 of 1

Exporting SQL

Posted: Thu Feb 27, 2003 10:18 pm
by moniarde
I wish to export a MySQL database I have created to a form that I can then upload to my isp and they can then create the database on the web server. I cannot connect to the isp's Mysql server, which is why I have to do it this way. I have been told in the past that I should be able to export it to a text file, but I have no idea how to do this, and the MySQL manual doesn't seem to say anything about it. Can anyone help at all?

Posted: Fri Feb 28, 2003 2:21 am
by twigletmac
Try using phpMyAdmin it can export all the data (and a tables structure) to a text file.
viewtopic.php?t=6275&highlight=export

Alternatively there is the command line.
http://www.mysql.com/doc/en/mysqldump.html

Mac