WordPress.org

Ready to get started?Download WordPress

Forums

WordPress 1.5 Database Manager (63 posts)

  1. Lester Chan
    Member
    Posted 9 years ago #

    Manages your WordPress database. Allows you to optimize database, backup database, restore database, delete backup database and run selected queries.

    DL: http://www.lesterchan.net/others/downloads.php?id=15

  2. mcmike
    Member
    Posted 9 years ago #

    very nice :)

  3. piginzen
    Member
    Posted 9 years ago #

    wow. this is excellent...

  4. Patti
    Member
    Posted 9 years ago #

    Yup, "excellent" is the correct term!

  5. Lester Chan
    Member
    Posted 9 years ago #

    thanks,
    hope that there is not much bugs =)

  6. piginzen
    Member
    Posted 9 years ago #

    I cant get the backup feature to work... It says it's backed up, but it's not in any directory...

  7. RaynerApe
    Member
    Posted 9 years ago #

    I am also having problems - the backup file is always 0-bytes.
    Otherwise excellent idea, I wish the author can fix the bugs and implement also "website backup in a tar.gz" similar to Backup/Restore plugin so I can ditch it.

  8. mmoy
    Member
    Posted 9 years ago #

    o bytes here too. Otherwise, great idea...

  9. Lester Chan
    Member
    Posted 9 years ago #

    hi all, if it is not backup, it means the mysqldump path is not the default one. Any idea on the path of your mysqldump?

  10. vkaryl
    Member
    Posted 9 years ago #

    Check your desktops.... I had this happen with my host's backup service a while back. I never put things on my desktop, so had no clue I needed to look there....

  11. RaynerApe
    Member
    Posted 9 years ago #

    GaMerZ, where do we check what the defaulyt mysqldump path?

  12. Lester Chan
    Member
    Posted 9 years ago #

    okie guys, check this line

    $backup['path'] = '..\\wp-backup-db';

    try changing it to the relative path $backup['path'] = '/path/to/wordpress/wp-backup-db';

  13. futb0l
    Member
    Posted 9 years ago #

    oo great idea.

  14. RaynerApe
    Member
    Posted 9 years ago #

    GamerZ, I tried that. At first changing to "/wp-content/backup" didn't produce anything, then I changed it to "../wp-content/backup" and I got a 0-byte SQL file. Is there something I am missing. Sorry for keeping you occupied on the subject and thanks in advance for any help.

  15. Lester Chan
    Member
    Posted 9 years ago #

    hi,
    it means the file is created in the directory but the file size is 0 bytes?

  16. RaynerApe
    Member
    Posted 9 years ago #

    Yes, that's exactly what I mean as 0-byte SQL file - .txt dump with 0 bytes of content. Empty file.

  17. piginzen
    Member
    Posted 9 years ago #

    I've tried every conceivable directory/path structure and have not got it to actually write a file...

  18. iammike
    Member
    Posted 9 years ago #

    As suggested before.. I got it to write and make a backup that isn't 0 bytes by changing the line:

    $backup['path'] = '..\\wp-backup-db';

    to this

    $backup['path'] = ABSPATH . 'wp-backup-db/';

    The previous post gave a path thats hardset .. by using ABSPATH it doesn't make it server specific, and will just pull your absolute path from the global variable. Or at least that worked for me.

    Not exactly sure whats causing people have have 0 byte files, mine makes a backup db thats 10 megs ...

  19. Lester Chan
    Member
    Posted 9 years ago #

    thanks for the fix iammike, i will update it.

  20. angusmaccuish
    Member
    Posted 9 years ago #

    To everyone who still gets a 0 byte backup file - does your wordpress MySQL database have an empty password ? If it does, then the mysqldump command line contains a '-p' instead of '-p <password>' and hangs. I discovered this on my local dev server - I now have a proper username/password on my dev database and the dump works fine.

    Great idea BTW!
    Gus

  21. gnawph
    Member
    Posted 9 years ago #

    How do we find out where our MYSQLDUMP is?

  22. Lester Chan
    Member
    Posted 9 years ago #

    cool info angusmaccuish, thanks

    gnawph: i think is /usr/bin/mysqldump

  23. RaynerApe
    Member
    Posted 9 years ago #

    Yes, empty password here, on a local apache.
    I hope this is the only problem. Thanks for letting us know, GaMerZ!

  24. Lorelle
    Member
    Posted 9 years ago #

    The link above takes us to a download page, at least when I tried it. Before I download something, I want to know a little more. So can you either point me in a direction to a page with more info before downloading or explain more about it here? Sounds neat.

  25. Joni
    Member
    Posted 9 years ago #

    I'm with Lorelle on this one. I keep a link list of sites that offer WP plugins. The links are to the plugin author's page or post that describes the plugin and offers a download link.

    I see on your main blog page you have an article called Updating my WP Plugins. There's no permalink or I'd have linked to that post. So for now, I'll link to your blog. I plan to upgrade to WP 1.5 very soon and this plugin will be at the top of the list of plugins for my site!

  26. roro
    Member
    Posted 9 years ago #

    Doesnt make me a backup, and in the restore window, all the ald backups have the same date from 1969

    Im using 1.5

  27. ceo
    Member
    Posted 9 years ago #

    I couldn't get this to work either. It never made a backup period, let alone one of 0 bytes. I finally gave up. :(

  28. bloodylamer
    Member
    Posted 9 years ago #

    there's a small issue that worked for me.

    Find:
    $backup['path'] = ABSPATH.'wp-backup-db';

    add the '/' to make it look like this:

    $backup['path'] = ABSPATH.'wp-backup-db/';

    before this change it wasn't making any backups on my end either & after, it worked like a charm!

  29. bloodylamer
    Member
    Posted 9 years ago #

    Oh also, thank you very much for the plugin, Gamerz! You are the man!!

  30. ceo
    Member
    Posted 9 years ago #

    Thank you for the tip, bloodylamer! That made it work perfectly for me!

Topic Closed

This topic has been closed to new replies.

About this Topic