Welcome, Guest. Please Login or Register.
November 21, 2017, 01:15:07 AM
Home Help Search Login Register
News: If you are still using YaBB SE, please consider upgrading to SMF as soon as possible.

YaBB SE Community  |  Development  |  Completed mods  |  Topic: [DONE] Backup DATABASE MOD « previous next »
Pages: [1] 2 Reply Ignore Print
Author Topic: [DONE] Backup DATABASE MOD  (Read 12809 times)
SK15
Jr. Member
**
Posts: 93


SK15 ESTA EM TODAS !!! - SK15 THIS IN EVERYBODY


WWW
[DONE] Backup DATABASE MOD
« on: June 12, 2002, 05:58:46 PM »
Reply with quote

Well it is that I missed that function in YaBB SE because other forums possesses it    
And I made a MOD of Backup of the database for YaBB SE the one that gave me a lot of Work ^ ^"    
   
He possesses 3 types of Backup that you can choose:
One is that you can Generate files *.sql why is the name its choice.
Another that he exhibits the data through the Browser in a <textarea></textarea>    
And for end you can save those files *.sql inside of the paste where its YaBB    
You can also choose the tables that will be made Backup.    
He only works in the version 1.4.0 why the tables they are pre-certain, I Wait in to Next versions to have removed that and him to know which are the tables of YaBB...    
But it is of easy change because it is only enough to place the name of the table in "Backup.php"    
   
Who wants to see them image they are below:
Choice of the Type of Backup and Tables

Exhibition of the Tables Through Browser

Donwnload:[/i]
Version for English
Backup_Mod_EN
Version for Portuguese
Backup_Mod_PT      
   
Up to now I didn't find any apparent error but I finished today he to find it can contact me.    
That, not for being mine but it is a very useful MOD to mine to see, and if it was included in the Next versions of YaBB SE will be very good.    
 
« Last Edit: June 12, 2002, 10:22:53 PM by SK15 » Logged
jthorpe
Sr. Member
****
Posts: 331



WWW
Re:Backup DATABASE MOD
« Reply #1 on: June 12, 2002, 06:39:58 PM »
Reply with quote

Just tar the db.  Takes about 10 seconds.
Logged
SK15
Jr. Member
**
Posts: 93


SK15 ESTA EM TODAS !!! - SK15 THIS IN EVERYBODY


WWW
Re:Backup DATABASE MOD
« Reply #2 on: June 12, 2002, 06:49:31 PM »
Reply with quote

The first part me in a I understood.  
But the delay for he gives for two causes some its DB this very big one...  
Or second is that the demarcations of Comments of the tables are harmed the formation of the same ones.
But here it is not so slow
« Last Edit: June 12, 2002, 06:52:02 PM by SK15 » Logged
David
Destroyer Dave
Global Moderator
YaBB God
*****
Posts: 5761


I'm not a llama!


WWW
Re:[DONE] Backup DATABASE MOD
« Reply #3 on: June 13, 2002, 07:49:48 PM »
Reply with quote

Thank you very much for writing this!

I reworded the english text for my board though.
Code: [Select]
$txt['backup0'] = "Database Backup Utility";
$txt['backup1'] = "Making a copy of the database";
$txt['backup2'] = "This tool allows you to make the backup of your database so that if anything happens to your forum you can recover its old data.<br>You can backup your board to your hardrive or view them in your browser.";
$txt['backup3'] = "Which type of backup do you want to generate?";
$txt['backup4'] = "File SQL(Download)";
$txt['backup5'] = "Display in Browser";
$txt['backup6'] = "Create Backup";
$txt['backup7'] = "Complete, The backup was successfully created!";
$txt['backup8'] = "Select Everything";
$txt['backup9'] = "Name";
$txt['backup10'] = "Select the tables you wish to backup";
$txt['backup11'] = "Yes";
$txt['backup12'] = "No";
$txt['backup13'] = "Table's structure";
$txt['backup14'] = "Dumping table's data";
$txt['backup16'] = "Save SQL on the Server";
$txt['backup17'] = "It was saved with success!";
Logged

Silver Dragon
Full Member
***
Posts: 157


Uh, Dragons are cool.


WWW
Re:[DONE] Backup DATABASE MOD
« Reply #4 on: June 13, 2002, 09:05:18 PM »
Reply with quote

Please forgive my ignorance, but is there also a easy way to restare the database?  For example, I want to install a new server, how can I port over my database?  Since it will be a different OS, I can't just IMG my drive :(

Being a SQL newbie, there may be an easy way to do this, but I don't know what it is.  

Thanks,

Dragon

Logged

David
Destroyer Dave
Global Moderator
YaBB God
*****
Posts: 5761


I'm not a llama!


WWW
Re:[DONE] Backup DATABASE MOD
« Reply #5 on: June 13, 2002, 11:13:09 PM »
Reply with quote

This mod doesn't seem to allow for restoring but that is probabally a feature that could be added.
Logged

SK15
Jr. Member
**
Posts: 93


SK15 ESTA EM TODAS !!! - SK15 THIS IN EVERYBODY


WWW
Re:[DONE] Backup DATABASE MOD
« Reply #6 on: June 14, 2002, 12:58:32 AM »
Reply with quote

David, That is normal my English it is a dirt.

Silver Dragon, I didn't understand some parts, excuse Me.  
But starting from the file *.sql that him you generate it possesses all the information of the tables you give its pots, members and the rest then there this.  
When you want to recuperate those data it is enough to go where you have access to the database as for example PHPMyadmin(http://www.phpmyadmin.net) that is a script of administration of the database, give to be a field where you seek that files you give then you seek the *.sql generated by the system and it places there he will execute like this all the commands returned to the normal.. don't only forget that "Settings.php" should be with the same value of the "db_prefix".  
If it is that that you say perhaps in the next version I will already place to execute those commands in own YaBB SE without I aid of others.
Logged
Ben_S
Disciple of Joe
Support Team
YaBB God
*****
Posts: 1586


I Love YaBB SE!


WWW
Re:[DONE] Backup DATABASE MOD
« Reply #7 on: June 14, 2002, 11:24:13 AM »
Reply with quote

Im on dialup and my forum DB is 32mb. Restoring that with phpmyadmin is impossible without splitting it into about 100 chunks...

Would be good if this mod saved the sql file to the server and there was a restore option to restore from the sql file thats on the server.

Its easy to download and upload the sql dump with ftp but through http with phpmyadmin I have no chance with that large a db
Logged
Trushna
Noobie
*
Posts: 49



Re:[DONE] Backup DATABASE MOD
« Reply #8 on: June 15, 2002, 06:11:27 PM »
Reply with quote

I suggest to implement zip and gzip compression (like in phpmyadmin...)
Logged

( 18/6/2002 ) * FIFA vs Italy : 2 - 1 *
tazthedev
Full Member
***
Posts: 161


I'm a llama!


Re:[DONE] Backup DATABASE MOD
« Reply #9 on: June 15, 2002, 06:33:25 PM »
Reply with quote


Im on dialup and my forum DB is 32mb. Restoring that with phpmyadmin is impossible without splitting it into about 100 chunks...

Would be good if this mod saved the sql file to the server and there was a restore option to restore from the sql file thats on the server.

Its easy to download and upload the sql dump with ftp but through http with phpmyadmin I have no chance with that large a db




yeah... like vbb did :)
Logged
CyberMix
Noobie
*
Posts: 6


I'm a llama!


WWW
Re:[DONE] Backup DATABASE MOD
« Reply #10 on: October 28, 2002, 09:19:01 AM »
Reply with quote

The link is dead!

http://hpg.ig.com.br/pg_404.html
Logged

-={Cyber|MIX}=-
PostDeals
Full Member
***
Posts: 112


Checkout postdeals.net for the latest deals.


WWW
Re:[DONE] Backup DATABASE MOD
« Reply #11 on: February 08, 2003, 09:04:50 AM »
Reply with quote

Link not working for me either.
Logged

For HotDeals, Coupons, Games Visit: www.postdeals.net

Thomas
Full Member
***
Posts: 203



WWW
Re:[done] Backup Database Mod
« Reply #12 on: February 02, 2004, 12:34:30 PM »
Reply with quote

The link is dead for me as well..

/Thomas
Logged
Spaceman-Spiff
Mod Team
YaBB God
*****
Posts: 3689


My $txt[228]


Re:[done] Backup Database Mod
« Reply #13 on: February 02, 2004, 05:24:33 PM »
Reply with quote

backup database is already available in YaBB SE, i dont remember since which version.
it's called Dump Database in your admin center
Logged

   My mods, ysePak, codes, tutorials
    Support question IMs = bad.
Thomas
Full Member
***
Posts: 203



WWW
Re:[done] Backup Database Mod
« Reply #14 on: February 03, 2004, 08:20:08 AM »
Reply with quote

backup database is already available in YaBB SE, i dont remember since which version.
it's called Dump Database in your admin center
I cant find where....

/thomas
Logged
Pages: [1] 2 Reply Ignore Print 
YaBB SE Community  |  Development  |  Completed mods  |  Topic: [DONE] Backup DATABASE MOD « 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.0.12 | SMF © 2016, Simple Machines
Valid XHTML 1.0! Valid CSS!
Page created in 0.095 seconds with 19 queries.