I need help with www.classonewatches.com
The site is in PHP and uses a database, here's the problem. The hosting company we are using is super slow and we changed our hosting company, but we are having a problem with transfering the database from Mysql to the new hosting company's Mysql. What is the easiest way to go about this?

Supposedly the old hosting company doesn't allow 3rd party software to connect and backup a copy of the database otherwise i would have done this. Also our phpadmin doesn't have a dump database feature or anywhere to put in the command to dump the database.

Any help on this would be much appreciated thank you

Originally Posted by seooptimizer

I need help with www.classonewatches.com
The site is in PHP and uses a database, here's the problem. The hosting company we are using is super slow and we changed our hosting company, but we are having a problem with transfering the database from Mysql to the new hosting company's Mysql. What is the easiest way to go about this?

Supposedly the old hosting company doesn't allow 3rd party software to connect and backup a copy of the database otherwise i would have done this. Also our phpadmin doesn't have a dump database feature or anywhere to put in the command to dump the database.

Any help on this would be much appreciated thank you

Can you get to a shell, or command-line at your current provider? I don't remember the details, perhaps someone here can, but you should be able to access all of the Mysql programs and dump everything to a file. That would be the way I would do it. It helps if the underlying OS is Linux too.

Wow, You had a really bad host.
This should do it -

mysqldump -u [username] -p [password] [databasename] > [backupfile.sql]

• [username] - this is your database username
• [password] - this is the password for your database
• [databasename] - the name of your database
• [backupfile.sql] - the file to which the backup should be written.

Make sure to get rid of the comments, and fill everything else in.
Take a look at http://www.devshed.com/c/a/MySQL/Bac...ySQL-Database/ before you go ahead and do anything. PHPMyAdmin has to have a query window you can add queries in. Backing it up through there would work unless your host as set it to were it won't. If it won't work there make a PHP file that will do this.
If this dosen't help let me know and I'll find another way that does.

Thanks for the reply matt,
The phpmyadmin does not have a command line all it has is an area where i can add product descriptions and prices etc... stuff like that maybe i'm not in the right area but there is no other links or tabs in the phpmyadmin, maybe its to old of a version.

I tried installing the new phpmyadmin 2.9.2 but having trouble setting it up. I am not very familiar with php as you can tell. But all i have to do is transfer this database and i'm done, hopefully.

Where would i find this other php file you were talking about. THANK YOU for all your help

Matt or anyone who is qualified, thats feels they can do this transfer, seamlessly. Please contact me at seospecialties@yahoo.com with pricing and a time frame as i am willing to pay to have this done in a timely manner. Having our site on this hosting is costing us money every day (loading slow). Would be happy to pay a (QUALIFIED) person to perform this.

I am willing to take this job.