How to do a local mysql database replication on an online server?

How to transfer mysql database to another server that doesn't allow creation of new databases?

I have a whole database already completed locally on my server and all I need to do is pass the SQL file and import it on another database server; however, the server I need to ...show more
Answer:

Export the file to the correct format for your import, obviously in this case export to sql. The very carefully edit out the name and creation section for the database. This is simply the first block of actual script. Then use whatever admin your hosting company allow to import all the tables into the named database.

ICUWJEUYH4DFZTU5PCM6EEDVH4 at Yahoo! Answers Visit the source

Was this solution helpful to you?

Other answers

You need to talk to the DBA to get the permissions you need. If you can't get the required permissions there is a reason.

EddieJ

If you can't make a database, you won't be able to make a table.

Franco

Related Q & A:

How to upload a file to another server using cURL and PHP?Best solution by Stack Overflow
How to manage MySQL database in Azure?Best solution by stackoverflow.com
How to Display an Image in PDF, which is retrieved from MySql Database :JSP and iText?Best solution by Stack Overflow
Why doesn't MySQL upload my data properly?Best solution by php-mysql-tutorial.com
Why doesn't my computer alert me of new e-mail?Best solution by Yahoo! Answers

Just Added Q & A:

How many active mobile subscribers are there in China?Best solution by Quora
How to find the right vacation?Best solution by bookit.com
How To Make Your Own Primer?Best solution by thekrazycouponlady.com
How do you get the domain & range?Best solution by ChaCha
How do you open pop up blockers?Best solution by Yahoo! Answers

For every problem there is a solution! Proved by Solucija.

Got an issue and looking for advice?
Ask Solucija to search every corner of the Web for help.
Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.