Issue Database Migration from MAMP failing

[Bram]

Hello,

A Wordpress website i have been working on in MAMP and on my personal hosting needs to go live on a Plesk server. However the Plesk server was outdated so data migration was doomed to fail. Now after they got their plesk server up to date i am still failing to import the database. Only a few tables from a plugin called Revolution slider are getting imported.

There must be something obvious i am missing and any help is much appreciated.

Kind regards,

Bram

 

[UFHH01]

Hi Bram,

unfortunately, you don't provide informations how you were trying to import the database. A basic command from the command line would be:

1. Login as root over ssh
2. use the command :

mysql -uadmin -p`cat /etc/psa/.psa.shadow` -D database_name < database_name.sql

or

mysql -uadmin -p`cat /etc/psa/.psa.shadow` --database=database_name < database_name.sql

( where "database_name.sql" should be either located at the current path, when you perform the command, or you choose the complete path, where "database_name.sql" is located on your server... i.e. "/var/www/vhosts/YOUR-DOMAIN.COM/httpdocs/db-upload/database_name.sql" )​