How to depooly a php site with mysql using phpmyadmin?
Hi guys i use wamp server and use phpmyadmin for DB, i am done with my web application, how to deploy it in a server, how to export the db and where to import the same. Some help will be surely acknowledged.
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.
__________________ PS3 Forums on GameSlurp - the site for gaming fans!
The Following User Says Thank You to Brook For This Useful Post:
You don't create a database with the vast majority of hosts, you upload the MySQL dump into the database they made and gave you.
If they didn't give you one, you have to upgrade your hosting package or change hosts.
Remember to match the database connection details of the online version to those given by the host. I keep the details in two files named, say connecton.php and connectlocal.php, but the site will use, say connectme.php When working on my home server, I open connectlocal.php and save as connectme.php. When I decide to upload, I open connecton.php and save as connectme.php. easy peasy. Only one file to update, and no details to edit by hand.