ibrown

I am a newbie and a student. I have MySQL running on my home box and I have a database that contains 3 tables that I would like to put on Surpass account site. How do I upload the DB and have it seen by MySQL tools in the cPanel?

Brian

Hmm..good question..I know but hard to put in words for you to understand

__________________

www.kanyeweb.net
www.industrytalk.net/forums

Server:Vega

sam

Hi ibrown.

basically -

run a mysqldump of your databases.

create the database in cPanel > mysqlAdmin if not already

then in phpMyAdmin - select the database and import the sql statements produced by the mysqldump for the respective databases.

remember that at surpass arll your mysql dbs must be prepended by your username ( cPanel will take care of this for you )

so lets say your username is ibrown

a db would be are ibrown_database1

remember you can't create the databaess from phpmyadmin - only from mysqlAdmin.

Brian

WooHoo..Thanks Sam..cause I was about to try

__________________

www.kanyeweb.net
www.industrytalk.net/forums

Server:Vega

ibrown

Wow.. that was easy.. Thanks.. it worked like a charm.. well as you instructed my local DB have to have the same name as the name created by the site.

sam

glad it worked. thanks for the followup.

now to close the loop.

the cpanel backup db tool produces a mysqldump of whatever db you like.

so what you can do is run that backup ( or schedule it to run - search for the phrase automagic in the forum )

and then from the mysqlmonitor at home - execute the sql produced by cpanel.

that way in your test/development environment you can have the latest and greatest active data from your site at the moment of the mysqldump.