Jump to content

exporting DB via phpMyAdmin - settings


fenton
 Share

Recommended Posts

Wouldn't it be simpler to export the database using some PHP script?

I've always thought that to be a better idea.

Why simpler? :)

When transfering a site locally to the server, I'm always using phpmyadmin.

Export all data to a mysql file takes me one minute, importing is just as easy.

I think it doesn't matter how you export your stuff - more important is (if there's no other backup running) to do it at all :)

  • Like 1
Link to comment
Share on other sites

When exporting with PHPMyAdmin, I sometimes have to uncheck the "use extended inserts" in order to get it to import somewhere else. Apparently the maximum query length can vary from server to server, and avoiding extended inserts reduces or eliminates that problem (at the expense of a slightly larger SQL file). 

  • Like 1
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...