0

When you try to import the database, the following message occurs: db error image

help me.

  • please mark answer if useful so others get solution on issue – Sourav Jun 12 '18 at 3:52
0

Import database use command line. By using this method full database will import without error.

Replace

  • username with your Database Username.
    databsase_name with your Database Name

    Paste this command with your credentional
    mysql -u username -p database_name > database.sql

    then paste password. ......

| improve this answer | |
  • Hello, Mark my answer – Sourav Jun 13 '18 at 2:58
0

I think your exported database backup is corrupted. Have you checked the DB backup file by opening in any text editor?

Sometimes, while exporting the database from phpMyAdmin, you get wrong format of file and it contains HTML tags.

In order to get correct database backup, you need to first export it using command line. Use the following command to export the database from origin server:

mysqldump -u username -p databasename > dumpfilename.sql

then provide the database login password when prompted.

To import the database using command line, use the following command:

cd [path to database backup file]

mysql -u username -p databasename < dumpfilename.sql

then provide the database login password when prompted.

| improve this answer | |
  • @VandersondeCastro, please upvote my answer if it helped, so that it can build trust for other users that answer is correct. – Mohit Kumar Arora Jun 13 '18 at 5:10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.