[DONE] Backup DATABASE MOD

[SK15]

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.    
 

[jthorpe]

Just tar the db.  Takes about 10 seconds.

[SK15]

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

[David]

Thank you very much for writing this!

I reworded the english text for my board though.

Code Select Expand

$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!";

[Silver Dragon]

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

[David]

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

[SK15]

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.

[Ben_S]

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

[Trushna]

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

[tazthedev]

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

[CyberMix]

The link is dead!

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

[PostDeals]

Link not working for me either.

[Thomas]

The link is dead for me as well..

/Thomas

[Spaceman-Spiff]

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

[Thomas]

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