Database backup-transfer

cnperry

I'm not extremely familiar with mySQL. I use it simply to store and retrieve records. That's it, so any help would be greatly appreciated.

I need to transfer the data from one DB to a DB on another server. The problem is that the DB sql dump file is much greater than the max post size allowed for PHP on the second server. I was thinking of simply setting up a PHP script that would go through all the records - read from server A and write to server B, but I realise that I will probably get a time-out on a large transfer (one of the tables is over 16M😎.

Since I don't have access to the php.ini (or any other configuration files, for that matter), what is the best approach to get the database copied?

Thanks!
Cameron

devinemke

you'll have to break the data down into smaller pieces. perhaps 1 SQL file that sets up all of your table structures and then other SQL files for the individual table data. for bigger tables you'll have to break it down further (maybe a few thousand rows at a time).

sanam

Try using Navicat (www.navicat.com). Download trial version, its good for 1 month. From there u can transfer data from one database to another.

cnperry

I think I'm going to try devinemke's suggestion to transfer in bits and pieces. Probably a fairly straightforward way is to copy a couple thousand rows at a time, then do an HTTP redirect after the appropriate php/mysql commands - keeping my place in the table stored and updated with session variables.

pseudocode:
start session;
if ($sessvars==NULL){
$sessvar[start];$sessvar[end];}
for($ii=$sessvar[start],$ii<$sessvar[end];$ii++)
{
if row$ii doesn't exist exit 0
else{
select row$ii from databaseA
insert row$ii into databaseB
}
}
$sessvar[start]+=20000;$sessvar[end]+=2000;
HTTP refresh

make sense?