Problem with database or database+prestashop transfer

[Aerikkala85]

Hi. I need a little help or at least push to the right direction. I have prestashop installed on my local computer and now i need to export database from local and import it to server. Exported file size is allmost 30mb. How can i import it to server, tryed once but got errors(sorry dont remember what errors). Is there a way to do it from command line? Also in mysql there was a mention of some prefix table name, how it can be changed. Thanks in advance

[Guillaume Freelance]

Hi,

 

Exporting your database through tools such as PHPMyAdmin often results in errors and problems when you import it again on the new server.

 

The safest solution would be to use "mysqldump" (google it if you don't know how to use it) on your local computer, and import it on your server, via the "mysql" command if you have command line access. Or zip the dump file and try to import it via PHPMyAdmin (ask your hosting provider where to find it).

[Aerikkala85]

Thanks guillaume, i try that. My hosting provider refused to increase execution time on server, so i think this method is only way to import large database at once.

[Thesouhail]

thanks i have the same problem, but now it's ok