CODEWITHSUNDEEP
mysql
Adam Scot
Adam Scot

Reputation: 1409

How to import a mySQL database without creating a new one

I'm trying to import a mySQL database into a clients hosting where privelidges in PHP Admin are extremely limited.

I am not able to create a new database, only work with the one they've given me.

When I upload the file with the database details in it.. I get an error telling me that the database already exists.

When I try and upload the database with the details for a new one... I get the error message that I am not allowed to create a new database.

What can I do to upload the contents of this database to the new one?

Upvotes: 5

Views: 2951

Answers (1)

Ray
Ray

Reputation: 41428

Edit your SQL dump file and get rid of the database create statement (and the drop database as well if one is there). Then import.

Upvotes: 5

Related Questions