How to depooly a php site with mysql using phpmyadmin?
View Single Post
04-12-2009, 05:56 PM
Join Date: Jul 2005
I'm a beginner too, but I'd say:
FTP all your files to your host
Create a new mysql database and user for your host account, then
(using SSH) Make a copy of your actual database: mysqldump --opt -u databaseuser -p databasename > /path/to/backupname.sql (and upload it to your host)
then load the copy into the new blank database you created: mysql -u databaseuser -p databasename < /path/to/backupname.sql
Replace databaseuser with the NEW User that you just created in STEP 2
Replace databasename with NEW Database Name you just created in STEP 2
Replace /path/to/backupname.sql with the path where you uploaded a copy of the actual database.
You will be asked for a password. Type in the NEW password as created in STEP 2 and press Enter.
That should be about it :) hopefully someone will say if I've gone wrong somewhere.
on GameSlurp - the site for gaming fans!
The Following User Says Thank You to Brook For This Useful Post:
View Public Profile
Send a private message to Brook
Find More Posts by Brook