How do I move a MySQL database?

[Guest]

Hi.

 

Thanks in advance for any help you can give me. A lot of my posts get blown by, so if you could spend three minutes responding, I would be thrilled.

 

I've been developing an osC solution for a promotional products company on my laptop, but now I need to move it to the website. How do I move my MySQL database, which is stored locally, to the web server? The database isn't created yet, but it will have the same name as my current database, "oscommerce".

 

If you could either answer this yourself or post a redirect to some documentation, I'd be so thankful.

 

Sincerely,

 

Mike Clemson

[ozcsys]

Hi.

 

Thanks in advance for any help you can give me. A lot of my posts get blown by, so if you could spend three minutes responding, I would be thrilled.

 

I've been developing an osC solution for a promotional products company on my laptop, but now I need to move it to the website. How do I move my MySQL database, which is stored locally, to the web server? The database isn't created yet, but it will have the same name as my current database, "oscommerce".

 

If you could either answer this yourself or post a redirect to some documentation, I'd be so thankful.

 

Sincerely,

 

Mike Clemson

The easiest thing to do is to backup your database in your osC admin, take that sql file and use it to populate your new database using phpmyadmin in your control panel of your domain. If you do not have that option run the install script to populate the database and then go into your osC admin and restore the database using your backup.