updating a whole db

[frizzo]

I have a site that is both stored on the web and on my own machine. I often make updates and add data to the one on my machine.

Until now the only way I know to update the live table is to export each table, then dump the live ones and do an update via the sql window on phpmyadmin

It's kind of laborious as there are several tables and I've been doing it all by hand. It would be really cool to somehow automate it but I'd be happy just to know of a quicker way in any case.

Is there a better way to do it? Some way to either compare two tables and automatically update the one, or can I just upload the mysql data file and thus overwrite the old one? Is there anything within a mysql data file that is specific to the machine it's being stored on, that would cause any problems if I just copied it over?

I don't have access to the mysql file via ftp. Is there a way to import a database or a table with phpmyadmin, other than via the sql window or text file?

What's the best method?

Thanks!!!
Frizzo

[nemonoman]

If you have shell access, you're all set.

If you don't you're hosed.

Do a dump of data for update using mysqldump or phpMyAdmin

Upload the file via ftp

then using shell access

log in to my mysql

mysql -uMyUserName -pMyPassWord MyDatabase < myDupfile.sql

Will cause the file to be executed, updating your database.

[frizzo]

Ok, thanks. I wanted to make sure there wasn't some brilliant method that I was missing out on 🙂