Back up of MYSQL to restore to different database name on different domain

If you’re replacing the content in the database, just drop all of the tables from the database and import your .sql file.

I have just tried this but get the following error:

SQL query:

# WordPress : https://www.sancere.com MySQL database backup
#
# Generated: Wednesday 29. September 2010 09:54 UTC
# Hostname: 213.171.200.64
# Database: nomadic1
# ——————————————————–
#
# Delete any existing table wp_additional_attendees
#
DROP TABLE IF EXISTS wp_additional_attendees ;

MySQL said:

#1142 – DROP command denied to user ‘condonp6’@’88.208.252.16’ for table ‘wp_additional_attendees’

Can you help

You need to set all capabilities for your database user on the database. This can usually be done via your hosting provider’s control panel. Unfortunately, exactly how to do that varies depending on your hosting provider, so I can’t be more descriptive than that.

James,

I have now sorted the permission issue a few tables have now been created but with now get this error, ?

SQL query:

#
# Data contents of table wp_events_attendee (23 records)
#
INSERT INTO wp_events_attendee
VALUES ( 1, ‘4c9f9ff4d15264.86015431’, ‘Condon’, ‘John’, ”, ”, ”, ”, ”, ”, NULL , ‘[email protected]’, ”, NULL , ”, 2010 -09 -2620 :33 :08, ‘Completed’, NULL , NULL , ‘0.00’, ”, NULL , NULL , ’09-26-2010′, ’19’, ’08:00 AM’, ’08:30 AM’, NULL ) ;

MySQL said:

#1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ’20:33:08, ‘Completed’, NULL, NULL, ‘0.00’, ”, NULL, NULL, ’09-26-2010′, ’19’, ” at line 1

James,

Manged to sort htis out it was a corrupt table. thanks for all your help really appreciate it.