MySQL Database uploading

[Anon]

Hello,

I am thinking of changing my hosting option from MS Access/ASP to MySQL/PHP. I've recreated the site MySQL/PHP code on my home computer and used DBTools to convert a 11MB MS Access database to MySQL.

Can phpMyAdmin's dump facility cope with transfering a large database to my ISP's server? or is there an alternative method to transfer the MySQL database to the server using FTP?

Thanks for any thoughts,

Brian

[[deleted]]

11MB is small.. very very small.

phpmyadmin is a nice tool, but it's complete crap when it comes to dumping and uploading.

Use the normal mysql commandline tools.

You can either upload the database with ftp and then load it into mysql on the server, or connect to the mysql server directly from your local mysqlm, something like this:

mysql databasename -hremotehost -uremoteuser -premotepassword < mysqldump databasename -hlocalhost -ulocaluser -plocalpassword --opt

[Anon]

Thanks Vincent for taking the time to reply. Just the information I was looking for.

Brian.