easy way to move database to new server

[ErikOS]

Is there an easy way to move database to new server with the data?

[Guest]

If you're using phpMyAdmin, you can export the database. Export it with full structure and full data as SQL code, not compressed. Go to the new database, and execute the SQL code. It will build the database tables and populate them with the data.

 

ed

[Guest]

you can also do a backup from the admin/tools area of the site, if you already have a store on the other site, just ftp the file into the backups directory there and then restore from admin/tools

[Guest]

John,

 

Will that work if a contribution added a table or column to the base osCommerce schema?

 

Thanks,

Ed

[ErikOS]

Thanks to the both of you!

[Guest]

you have to have the code in place to use the table or field if they are in the db.

if all you are doing is changing servers or moving the data from local to a web server you can do it this way.

some hosts do limit how much data you can xfer via php, which is a real pain for the people who have large db's unless they control their own server.