Moving site to new server~ Multiple database errors / issues

[Peteh]

Hi

I am in the process of moving several sites to a new server and the move has stumped me !

Over the last few days i have had more php error code's, messages and re-installed several times until now i am here asking for help  

So i am starting afresh ................ again!

So backed up database, transfer via ftp all files to new server, made new "test" database and all good until i go to install my DB.

First problem is " Script timeout passed, if you want to finish import, please resubmit same file and import will resume."

Its quite a large file, 13mb zipped, but not as big as some DB's already transferred for other CMS systems.

I have already reset the maximum time to infinity with $cfg['ExecTimeLimit'] = 0;

Then i try to resubmit, as it tells me and get the message " #1050 - Table 'bs4ml_assets' already exists "

Any suggestions please?

Pete

[El Patron]

Then i try to resubmit, as it tells me and get the message " #1050 - Table 'bs4ml_assets' already exists "

 

you would need to drop (clean out) all tables before re-importing.

[Peteh]

Hi

 

Thanks for the reply............

 

Tried that and it gives the time out message again 

[El Patron]

Hi

 

Thanks for the reply............

 

Tried that and it gives the time out message again 

 

try doing it without db dump zipped.

 

else you may need to contact your hosting company as the infinity you  set may not be honored by hosting account override.

[Peteh]

Hi

 

Thanks again for trying to help, i do appreciate it.

 

Tried importing without being zipped, times out.

 

The hosting is on a virtual server where i set the settings.

 

Is the code i used correct?

 

Is there no other way of importing the database in several parts?

[vekia]

btw. while exporting table you can select "drop tables & create new" this code will remove all tables that exists.

it's worth to try.

[benjamin utterback]

You should not need to import a 13MB database in several parts. 

 

If you have access to the php.ini file, you could take a look at this post that might help. http://www.prestashop.com/blog/en/php-ini-file/