Print Page - Can't import database from old host.

Title: Can't import database from old host.
Post by: Dan_ on October 07, 2023, 11:45:43 AM

I keep getting this error and everything comes to a halt.

" MySQL said: (https://a2plcpnl0358.prod.iad2.secureserver.net:2083/cpsess6582351936/3rdparty/phpMyAdmin/themes/dot.gif) (https://a2plcpnl0358.prod.iad2.secureserver.net:2083/cpsess6582351936/3rdparty/phpMyAdmin/url.php?url=https%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.7%2Fen%2Ferror-messages-server.html)

Code Select

#1050 - Table 'backup_eaglersnestadmin_info_files' already exists

Title: Re: Can't import database from old host.
Post by: Doug Heffernan on October 07, 2023, 12:14:04 PM

Quote from: Dan_ on October 07, 2023, 11:45:43 AMI keep getting this error and everything comes to a halt.

" MySQL said: (https://a2plcpnl0358.prod.iad2.secureserver.net:2083/cpsess6582351936/3rdparty/phpMyAdmin/themes/dot.gif) (https://a2plcpnl0358.prod.iad2.secureserver.net:2083/cpsess6582351936/3rdparty/phpMyAdmin/url.php?url=https%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.7%2Fen%2Ferror-messages-server.html)
Code Select Expand
#1050 - Table 'backup_eaglersnestadmin_info_files' already exists

You are trying to import in a full database where the tables in the backup file already exist there. The backup is obviously made without the drop table if exists command. You should drop the tables from the database and import the backup.

The tables with the backup_ prefix are usually backup tables made prior to an upgrade by the upgrader. So they can be safely excluded when making a backup, unless that is what you are using as the database tables.

Title: Re: Can't import database from old host.
Post by: Dan_ on October 07, 2023, 01:08:03 PM

Made new backup with that box ticked and this happened...

(https://premium226.web-hosting.com:2083/cpsess5777276274/3rdparty/phpMyAdmin/themes/dot.gif) Import has been successfully finished, 2971 queries executed. (localhost.sql(1).zip)

Thanks so much for your expertise and being here to help.

Marking it solved1

Title: Re: Can't import database from old host.
Post by: Doug Heffernan on October 07, 2023, 02:10:21 PM

Quote from: Dan_ on October 07, 2023, 01:08:03 PMMade new backup with that box ticked and this happened...

(https://premium226.web-hosting.com:2083/cpsess5777276274/3rdparty/phpMyAdmin/themes/dot.gif) Import has been successfully finished, 2971 queries executed. (localhost.sql(1).zip)

Thanks so much for your expertise and being here to help.

Marking it solved1

I am glad that I could help.

Simple Machines Community Forum

SMF Support => SMF 2.0.x Support => Topic started by: Dan_ on October 07, 2023, 11:45:43 AM