Migrate database from shared hosting to AWS Lightsail with WHM

stepup88

• October 23, 2023 04:15

Hi, I face a prblem for migrating a database around 200mb from shared hosting to my own AWS Lightsail with WHM My current shared hosting disable backup function in cPanel. I can only export it from phpmyadmin or request provider to do it. after i download the backup file, how do I import it to the database if I upload the database file at file manager. Any tutorial for cpanel beginner?

• 

  quietFinn

  • October 23, 2023 10:15

  in root ssh go to the directory where the mysql database dump is and do: mysql DATABASE < DATABASEDUMP.sql (of course create the database 1st).

  0
• 

  SimpleSonic

  • October 23, 2023 13:16

  in root ssh go to the directory where the mysql database dump is and do: mysql DATABASE < DATABASEDUMP.sql (of course create the database 1st).

  
  The OP's current hosting is shared, so doubtful he has root access.

  0
• 

  cPRex Jurassic Moderator

  • October 23, 2023 14:37

  @stepup88 - you can import the database with PHPMyAdmin as well:

  0

Please sign in to leave a comment.