Exporting SQL
Moderator: General Moderators
- moniarde
- Forum Newbie
- Posts: 20
- Joined: Thu Feb 06, 2003 12:45 am
- Location: Perth, Western Australia
Exporting SQL
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?
- twigletmac
- Her Royal Site Adminness
- Posts: 5371
- Joined: Tue Apr 23, 2002 2:21 am
- Location: Essex, UK
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
viewtopic.php?t=6275&highlight=export
Alternatively there is the command line.
http://www.mysql.com/doc/en/mysqldump.html
Mac