Announcement

Collapse
No announcement yet.

My SQL Dump Problem - pls assist!

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • My SQL Dump Problem - pls assist!

    Hi, I was wondering if anyone can help me figure this out.
    I always do mysql dumps thought the years of running this forum.
    I do it to backup the db.

    Today I tried doing it via the shell as always. Everything normal.
    Seems to be working. Then when looking at the dumped .sql file
    it is 0kb. Empty.

    Any ideas on why? I need to backup this forum because its moving
    servers. Any help would be appreciated!
    JackG

  • #2
    Do you include the password in your commandline?

    For security reasons, you can no longer do something like:
    mysqldump -ufeldon23 -pXXXXXXX --opt db_name > backup.sql

    You must do
    mysqldump -ufeldon23 -p --opt db_name > backup.sql
    and enter the password manually.

    Comment


    • #3
      Yes, that is what I did.
      I have done it many times.

      This time..it hangs like usual whicle creating the dump.
      It creates the file name - but it is Zero Kilobytes.
      Now..my db is at least 500 mb in size

      Does anyone have any ideas? I relly need to solve this issue.
      JackG

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...
      X