OK, I will be the first to admit I am not Telnet or SSH savvy...so I rely on my phpMyAdmin to adminstrate my databases. I am trying to move a database that is about 17MB big, and the server keeps timing out when I try to DUMP. Here is the setup.
w3t_AddressBook Browse Select Insert Properties Drop Empty 501 16.7 KB
w3t_Banned Browse Select Insert Properties Drop Empty 0 1.2 KB
w3t_Boards Browse Select Insert Properties Drop Empty 16 8.4 KB
w3t_Category Browse Select Insert Properties Drop Empty 4 3.5 KB
w3t_Favorites Browse Select Insert Properties Drop Empty 12 7.5 KB
w3t_Groups Browse Select Insert Properties Drop Empty 14 2.3 KB
w3t_Last Browse Select Insert Properties Drop Empty 1,754 90.4 KB
w3t_Messages Browse Select Insert Properties Drop Empty 339 1.0 MB
w3t_ModNotify Browse Select Insert Properties Drop Empty 1 2.0 KB
w3t_Moderators Browse Select Insert Properties Drop Empty 24 2.6 KB
w3t_Online Browse Select Insert Properties Drop Empty 11 7.8 KB
w3t_PollData Browse Select Insert Properties Drop Empty 619 322.5 KB
w3t_Polls Browse Select Insert Properties Drop Empty 102 71.7 KB
w3t_Posts Browse Select Insert Properties Drop Empty 14,669 15.2 MB
w3t_Ratings Browse Select Insert Properties Drop Empty 284 18.1 KB
w3t_Subscribe Browse Select Insert Properties Drop Empty 24 2.9 KB
w3t_Users Browse Select Insert Properties Drop Empty 257 372.2 KB
Not too big really...
I have successfully moved over ALL tables but my w3t_Posts, which is the 15.2MB line above. Each time I try to use phpMyAdmin to DUMP just the table data - it times out. It will not send either. I have already pared this w3t_Posts table down from 34,000+ posts to 14,669 above...and it still will not allow me to grab it.
Any help would be appreciated. Again, if you tell me to use SSH - remember I am a NEWB to commands there...and have no idea how to gzip and move a database.
Thanks for any suggestions.
