Main Stories
Slash Boxes

Slash Open Source Project

Slashcode Log In

Log In

[ Create a new account ]

Article Poll

Poll I found this article to be
Very Helpful
Not Helpful
Not Very Helpful
[ Results | Polls ]
Comments:0 | Votes:0

Recreating Authors Table

posted by Krow on 08:23 PM January 25th, 2001   Printer-friendly   Email story
DarkMoon writes "Ooops, I was taking a peek into the DB tables, an ICQ msg came in and I pressed the wrong button and deleted the Authors table....
How do I re-create that particular table?

Course, you are going to need more the the table, you will need the authors names and such themselves.
This discussion has been archived. No new comments can be posted.
The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
More | Login
Loading... please wait.
  • Are there any examples of perl/shell scripts to do a dayli dump?

  • You are using the beta of Slash, while this discussion seems to be about the main branch.
  • I have even problem creating new author. It complains: "[error] Can't locate object method "createAuthor" via package "Slash::DB" at /usr/local/slash/site/myslashsitename/htdocs/admin .pl line 298."
  • Ahh, the joys of doing a dump everyday. Data loss prevention is a way of life for a website/database person. You should do a dump daily of your databases, if they are important to you, compress them, then move them off that computer on two atleast 2 different ones.

    It's either on the beat or off the beat, it's that easy.
  • oops, the second one should be slash2 > slash2.sql

    It's either on the beat or off the beat, it's that easy.
  • basically, you do something like this, on a user account that can access all the databases you want.

    mysqldump --opt slash > slash.sql
    mysqldump --opt slash2 > slash.sql
    mysqldump --opt mysql > mysql.sql
    lha -m dumps.lha *.sql

    Something like that. It would be cool to mod this to append the date to the .lha archive file, but thats beyond my shell scripting abilities. If you could append it to the lha file, then you could set up a cron job to do it.

    Maybe it's time to find out how to do a little more shell stuff....


    It's either on the beat or off the beat, it's that easy.
  • by Anonymous Coward
    If this is to happen during using any app, it's ICQ, POS software.