Which tables?

[Mangler]

Howdy, hope this is the correct forum for this. (vb 2.3.0)

I recently migrated my site and worked on it in the new location till I had it right. In the mean time, the existing site had some new members and posts occur.

Can someone please tell me which tables to get in order to get the members and posts over to the new host?

[Steve Machol]

The only way to do this correctly would be to backup and restore the entire database again.

[eva2000]

Howdy, hope this is the correct forum for this. (vb 2.3.0)

I recently migrated my site and worked on it in the new location till I had it right. In the mean time, the existing site had some new members and posts occur.

Can someone please tell me which tables to get in order to get the members and posts over to the new host?
you need to backup all tables using mysqldump or one of the proper ways to backup explained and illustrated here http://www.sitepoint.com/article/678

[Mangler]

Thanks, was afraid of that,lol.

[eva2000]

Thanks, was afraid of that,lol.
yeah moving servers can be troublesome to sync new users and all, hence why i close the old/existing forum for 1 - 4 days while the new forum is migrated to ensure new posts/users go to the new location - it's the only way

[stark427]

I have one question here.
If the whole database is needed, then what's the use of the :

"Database tables to include in backup - Do backup" function.

I'm kind of confused here.

If I backup the whole database via the "Save data to file on server:" way, the file which is stored on the server is around 200MB

If I choose the first way on the admin panel (Do Backup - having chosen all the tables except the search index) I get a file 41 MB

what's the difference between these two backups?

thanx in advance

[eva2000]

using phpmyadmin or vB admin backup via php scripts will timeout on large data backups.. those options allow separating the size of each backup session ... but i don't recommend using phpmyadmin or vB admin backup as it will time out giving incomplete backups like the one you have

41MB is because backup timed out and didn't complete...

you need to use mysqldump via ssh telnet http://www.sitepoint.com/article/678 for properly backing up

[stark427]

Thanx for the reply.

My host does not provide me with telnet access, which means that I cannot use the mysqldump utility.

However, he has enabled automatic backups and the files are gonna be saved on the server so that I can download them

Still, the first automatic backup is (zipped with winrar) only 32MB... and I'm kind of worried... isn't it too small for a 200MB original file?

Or is the SQL files only text, so they can be compressed that much ?

stark

[stark427]

Never mind, I just unzipped the file and it is 371MB (!!)

so it should be fine

[eva2000]

Never mind, I just unzipped the file and it is 371MB (!!)

so it should be fine
how can the uncompressed backup be larger then the original 200MB ?

i'd try and setup a local apahce/php/mysql system on a home pc and setup a vb copy and import that backup you get and check to see if it's the proper full backup