Welcome, Guest. Please Login or Register.
April 28, 2025, 11:20:14 AM
Home Help Search Log in Register
News: SMF is the next generation in forum software, almost completely re-written from the ground up, make sure you don't fall for cheap imitations that suffer from feature bloat!

YaBB SE Community  |  English User Help  |  English Help  |  Database Backup. « previous next »
Pages: [1] 2 Reply Ignore Print
Author Topic: Database Backup.  (Read 827 times)
WedgeAntilles250
Guest
Database Backup.
« on: January 07, 2002, 05:25:24 AM »		 Reply with quote
Are there any plans to make a database backup routine for YaBBSE?

You know, a backup routine to backup the MySQL database into a text file for backup purposes.
Logged
Tore
Guest
Re:Database Backup.
« Reply #1 on: January 07, 2002, 08:31:25 AM »		 Reply with quote
This can be easly done with phpmyadmin
Logged
Jeff Lewis
Global Moderator
YaBB God
*****
Posts: 10149


I'm a llama!

WWW
Re:Database Backup.
« Reply #2 on: January 07, 2002, 12:32:15 PM »		 Reply with quote
We have one that works pretty much in regular PHP setups, but naturally safe mode wants to be a pain in the ass.
Logged

My Amazon Wishlist
My Blog
WedgeAntilles250
Guest
Re:Database Backup.
« Reply #3 on: January 07, 2002, 03:48:32 PM »		 Reply with quote
Quote from: Jeff Lewis on January 07, 2002, 12:32:15 PMWe have one that works pretty much in regular PHP setups, but naturally safe mode wants to be a pain in the ass.
Can I have it?  My hosting service isn't in Safe Mode.
Quote from: Tore on January 07, 2002, 12:32:15 PMThis can be easly done with phpmyadmin
How would I do this?
Logged
Jeff Lewis
Global Moderator
YaBB God
*****
Posts: 10149


I'm a llama!

WWW
Re:Database Backup.
« Reply #4 on: January 07, 2002, 06:08:37 PM »		 Reply with quote
In phpmyadmin you just make a dump of sturcture and data, it will print out a dump file which you can copy and paste into a file...

As for what we have...you'll have to wait, unless Ted comes and answers differently.
Logged

My Amazon Wishlist
My Blog
WedgeAntilles250
Guest
Re:Database Backup.
« Reply #5 on: January 07, 2002, 07:59:36 PM »		 Reply with quote
Well, I have found out how to do a MySQL DB dump at the command line.

To Backup
/usr/local/mysql/bin/mysqldump <DATABASE> -u <USERNAME> -p<PASSWORD> > /YaBBDB.dump

To Restore
/usr/local/mysql/bin/mysql <DATABASE> -u <USERNAME> -p<PASSWORD> < /YaBBDB.dump

But to see it in a GUI form in the board itself would be very nice.
« Last Edit: January 07, 2002, 09:05:17 PM by WedgeAntilles250 » Logged
jthorpe
Sr. Member
****
Posts: 331


WWW
Re:Database Backup.
« Reply #6 on: January 07, 2002, 08:07:23 PM »		 Reply with quote
Can't you just TAR it and ftp it somewhere?  
Logged
WedgeAntilles250
Guest
Re:Database Backup.
« Reply #7 on: January 07, 2002, 09:04:22 PM »		 Reply with quote
No, because it uses MySQL.
Logged
Joseph Fung
Global Moderator
YaBB God
*****
Posts: 4512


Keep smiling: it makes others nervous.

WWW
Re:Database Backup.
« Reply #8 on: January 08, 2002, 09:13:47 PM »		 Reply with quote
oh yeah - just so you know, this util will be included in the maintenance release.  although safe-mode people are still SOL
Logged
jthorpe
Sr. Member
****
Posts: 331


WWW
Re:Database Backup.
« Reply #9 on: January 09, 2002, 03:18:52 AM »		 Reply with quote
Quote from: WedgeAntilles250 on January 07, 2002, 09:04:22 PMNo, because it uses MySQL.

Can't you tar the mysql info?  that is what I have been doing but i don't know for sure if it would work.  I just take my /var/lib/mysql stuff and tar it.  I imagine if I had to restore, I could just re-create the database in mysql, then tar the original stuff back in.  I imagine it would work since all of the stuff would be the same.  Am I mistaking here?
Logged
WedgeAntilles250
Guest
Re:Database Backup.
« Reply #10 on: January 09, 2002, 03:37:57 AM »		 Reply with quote
Ok, so you got me there, but I don't have that level of server access.  I am hosted remotely you know.
Logged
Razgo
Full Member
***
Posts: 125


Dance with the Beat

ICQ - 144284881 WWW
Re:Database Backup.
« Reply #11 on: January 09, 2002, 10:17:02 AM »		 Reply with quote
in my "phpMyAdmin" i have version 2.2.2
and MySQL 3.23.45

it has the option now to simply put a tick in the"save file as" box. so I save it as a SQL file for easy restoral.
Logged
RioWorld mp3player forums Coffee House Forum
Jeff Lewis
Global Moderator
YaBB God
*****
Posts: 10149


I'm a llama!

WWW
Re:Database Backup.
« Reply #12 on: January 09, 2002, 01:27:05 PM »		 Reply with quote
Yes, phpmyadmin is very nice :)
Logged

My Amazon Wishlist
My Blog
jthorpe
Sr. Member
****
Posts: 331


WWW
Re:Database Backup.
« Reply #13 on: January 09, 2002, 09:02:16 PM »		 Reply with quote
ok so I am a moron.  What is phpmyadmin?
Logged
Joseph Fung
Global Moderator
YaBB God
*****
Posts: 4512


Keep smiling: it makes others nervous.

WWW
Re:Database Backup.
« Reply #14 on: January 09, 2002, 09:14:16 PM »		 Reply with quote
It's a fun little PHP-port of BackOrifice letting you remotely control someone's PC  ;D
Logged
Pages: [1] 2 Reply Ignore Print 
YaBB SE Community  |  English User Help  |  English Help  |  Database Backup. « previous - next »
 


Powered by MySQL Powered by PHP YaBB SE Community | Powered by YaBB SE
© 2001-2003, YaBB SE Dev Team. All Rights Reserved.
SMF 2.1.4 © 2023, Simple Machines
 Valid XHTML 1.0! Valid CSS

Page created in 0.030 seconds with 18 queries.