Mysql

[Guest arkosh]

Can I upload a mysql database that I created on my local machine to the server, via ftp, or do I have to create a new one with cpanel?

 

Thank You

[chuckmalani]

you can use the mySQL dump function to create a SQL which will re-create and populate the DB the way it is.

 

then FTP that SQL to your TCH server, and run the SQL in phpMyAdmin.

 

here is mySQL documentation on dump()

 

http://www.mysql.com/doc/en/mysqldump.html

 

hope this helps,

chuck

[Guest arkosh]

Thanks for reply FSU

 

Im just eaching myself mysql, and wanted to know before I started to build database.

When Im done I will try this method, hopefully it all works out

 

Thanks again