MYSQL/ phpadmin help

[dreamcastrocks]

Is there anyone here that worked with these two programs?

I am trying to migrate one MYSQL database into another on the same server. I have tried just exporting/importing the data, but I am receiving access denied errors.

Any suggestions?

 

[Ryanwb]

What program did you use to migrate the database? PHPMYADMIN? What operating system is this? Unix/Linux or windows? If it's Linux you have to chmod the file to 777 before you import it

 

[Mike Olbinski]

You should just be able to do a SQL export to a file, which ends in .sql, then use that to import into something else.

However, if you are importing it back into the same MySQL DB, it may be trying to overwrite the same tables names you exported, which probably is the reason you are getting permission errors.

Just make sure your import isn't going into the same place as the old DB.

 

[dreamcastrocks]

What program did you use to migrate the database? PHPMYADMIN? What operating system is this? Unix/Linux or windows? If it's Linux you have to chmod the file to 777 before you import it

You should just be able to do a SQL export to a file, which ends in .sql, then use that to import into something else.

However, if you are importing it back into the same MySQL DB, it may be trying to overwrite the same tables names you exported, which probably is the reason you are getting permission errors.

Just make sure your import isn't going into the same place as the old DB.

Thanks for the help. I think the problem was when I was doing the export, I was not checking the "Add DROP tables" checkbox.

I also started exporting a few tables at a time, rather than the entire database and that worked better for me.