Can't import database from old host.

[Dan_]

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

" MySQL said:

Code Select Expand

#1050 - Table 'backup_eaglersnestadmin_info_files' already exists

[Doug Heffernan]

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

" MySQL said:

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.

[Dan_]

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

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

[Doug Heffernan]

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

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.