PDA

View Full Version : Uploading Mysql Database to Server!!


tux
05-01-2008, 11:49 AM
Hi all,

Having nearly finished converting an old static site to CSS and PHP, I will soon be ready to upload it from my delevoper environment and go live.

I have uploaded databases to the server before but never a Mysql DB. I use EMS MYSQL Lite. Could anyone point me in the right direction.

Cheers.

Regards, Paul.

pete
05-01-2008, 12:17 PM
You need to dump the database first, so on your local/dev server do this:

mysqldump --opt -uuser -ppass -hlocalhost dbname > db.sql

then on the production server upload the file db.sql, do

mysql -uuser -ppass -hlocalhost dbname < db.sql

Obviously change your user and passwords and you may need to create the database via your host admin, if CPanel or Plesk host use the control panel. On some hosts you may be able to do it yourself with

mysqladmin create dbname;

davidj
05-01-2008, 03:39 PM
in EMS MYSQL Lite. there is a backup db in tools menu