You might get a time out with phpMyAdmin The many web hosts I have used pretty much have all used php's default 90 second exection time for php pages.
I have a zip code database with 50,000 records and had to do this import through a ssh session On the web server using mysqldump on the old server and "cat *.sql |mysql ..." on the new. Assuming PowWeb doesn't do shell accounts (very few web hosts do these days) Search google for "telnet.cgi" This is a cgi script that allows you to give commands on the webserver. This gives you a textbox To enter your command in, click "submit" and it runs the command. With this, you should be able to run mysqldump to export the database, pipe to gzip, and create a file That you can download and upload to your rackspace server. You should be able to do the md5 sum like James suggests using the same telnet tool md5sum export.sql.gz Then after you upload, run the same command to make sure you didn't loose any bits in the transfer. -- George > -----Original Message----- > From: JamesDR [mailto:[EMAIL PROTECTED] > Sent: Monday, February 06, 2006 11:54 AM > To: mysql@lists.mysql.com > Subject: Re: Moving from PowWeb to Rackspace > > Brian Dunning wrote: > > I have a bunch of databases - some are really big, 2GB - on > a number > > of different accounts at PowWeb. I am buying a Rackspace server and > > want to move everything over -- hopefully all in one night. > Can anyone > > suggest the best way to do this? Would it be to use the > Export command > > in phpMyAdmin? > > > > --MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > I'm not familiar with phpMyAdmin, but I would dump everything > to sql files, using the extended insert option then > compressing the resulting sql files. Then create a hash (MD5) > and ftp the files over, checking the hash on the remote > system, uncompressing, and importing. I do something like > this with my backups (all automated, except for the checking > of the hash on the remote system, I just store the MD5 in an > ascii file.) > > -- > Thanks, > James > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
