Arch Linux

rado3105

Member

Registered: 2011-10-09

Posts: 103

(SOLVED)Problem to recover backup created using mysqldump, shows error

I use this command to restore:
mysql -u root -ppasswd db1 < /media/wd1500GB/backup/mysql/db1_2014-03-28.sql

Shows this error:
ERROR 1050 (42S01) at line 25: Table '`db1`.`phpbb_acl_groups`' already exists

Mysql is running.
What can be wrong? thanks

Last edited by rado3105 (2014-03-31 09:02:32)

Tarqi

Member

From: Ixtlan

Registered: 2012-11-27

Posts: 179

Website

Re: (SOLVED)Problem to recover backup created using mysqldump, shows error

If this is a full backup, drop the database first and create a new (empty) one. Then restore your backup.

---

Knowing others is wisdom, knowing yourself is enlightenment. ~Lao Tse

rado3105

Member

Registered: 2011-10-09

Posts: 103

Re: (SOLVED)Problem to recover backup created using mysqldump, shows error

It worked thank you very much

karol

Archivist

Registered: 2009-05-06

Posts: 25,440

Re: (SOLVED)Problem to recover backup created using mysqldump, shows error

Please remember to mark the thread as solved https://bbs.archlinux.org/viewtopic.php?id=130309