Exporting SQL

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
moniarde
Forum Newbie
Posts: 20
Joined: Thu Feb 06, 2003 12:45 am
Location: Perth, Western Australia

Exporting SQL

Post 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?
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post 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
Post Reply