mysqldump help?

by 3 replies
4
I have a database on my local machine. It's to big to backup via phpmyadmin export.

I am trying to use mysqldump but I'm obviously not smart enough.

My DB name is parse, table name is data, user is root, no password. I want a .sql file output in a directory like c:\wamp All I really want is the table, but the whole DB is fine if it's easier.

Can someone give me the line of code to put in mysql console to accomplish this?

I've searched all over the web, but I'm obviously doing something wrong.
#programming #mysqldump
  • "Fortunately, there is an easy solution for this issue. Instead of selecting all tables in the database and then exporting them, you should export the large database by selecting only several tables at a time.

    This way, if you wish to import the database, you will have to import smaller SQL dumps and thus you will avoid a phpMyAdmin timeout during the import process."

    OR:

    Code:
    mysqldump -u root -p parse > filename.sql
    • [1] reply
    • Thanks for the reply. I just use windows command line for this or the mysql console? Off to try it now.

      I just tried windows command line..

      I get myslqdump is not recognized as an internal or external command, operable program or file. Off to try mysql console I guess.
  • Well, first you should have mysqldump.exe then using the windows command line you use the command cd (change directory) to navigate in the same directory where the mysqldump executable should be. Only then you can use the mysqldump command.
Join the discussion

Next Topics on Trending Feed

  • 4

    mysqldump help?

    I have a database on my local machine. It's to big to backup via phpmyadmin export. I am trying to use mysqldump but I'm obviously not smart enough.