vb.org Archive - Backup/Restore ANY Forum WITHOUT SSH

Page 2 of 4

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Programming Articles (https://vborg.vbsupport.ru/forumdisplay.php?f=188)

- - Backup/Restore ANY Forum WITHOUT SSH (https://vborg.vbsupport.ru/showthread.php?t=144966)

NolF	04-21-2007 07:11 AM

Thx It finally work

Quote:

Originally Posted by TruthElixirX

Since you created the folders

That quote seem to give me the idea.

It was a mix of deleting and creating again the folders in 777. Aparently the ones it creates automatically are no good, so...

When you get the green tick on work delete all the 4 subfolders, and make them again, put them in 777 run the script again and it should work. At least it did for me. If not, try to run combinations of deleting, runing the check script and making folders in 777

----PS
backed up my forums, very easy no problems, hope I'll never need to restore one of them but... I'll write my experience if it happens :=)
Thx again TruthElixirX :)

TruthElixirX

04-21-2007 11:58 AM

Quote:

Originally Posted by NolF (Post 1232485)

Thx It finally work

That quote seem to give me the idea.

It was a mix of deleting and creating again the folders in 777. Aparently the ones it creates automatically are no good, so...

When you get the green tick on work delete all the 4 subfolders, and make them again, put them in 777 run the script again and it should work. At least it did for me. If not, try to run combinations of deleting, runing the check script and making folders in 777

----PS
backed up my forums, very easy no problems, hope I'll never need to restore one of them but... I'll write my experience if it happens :=)
Thx again TruthElixirX :)

No problem, I'll add your advice to the first post.

beduino

04-27-2007 10:16 PM

Hi,
myqslqdumper is a fine opensource work :)
I translate do portuguese br [see in site] and i really like the program ... but... I don't know how we can automatize the script. I think is a pearl script.
But i don't have any ideia how can i make the script.

Anybody can help?

All the best
Beduino

TruthElixirX

04-27-2007 10:57 PM

Quote:

Originally Posted by beduino (Post 1236723)

Not sure what you mean. You can set up a cron job to run it every so many hours.

Coders Shack

05-16-2007 06:48 AM

SSH...

To login and backup a database in one line:

Code:

mysqldump --password=[password] -h [hostname] -u [username] [databasename] > [backupfile.sql]

To restore a database in one line:

Code:

mysql --password=[password] -h [hostname] -u [username] [database_to_restore] < [backupfile]

I use the backup cmd in an automated backup script which saves the file then uploads the file to a backup server.

music legend

10-12-2007 06:09 AM

i used this method to move mysite to another server and the database restored successfully and the site and everything is there but when i got to make a new post for some reason it ends up quoting old post for no reason and doesnt display what i typed in for the post....any ideas why?

needaltuna

11-11-2007 03:09 AM

Thanks for this much-needed tutorial.

I had no problems installing mysqldumper, but I have had some with creating directory protection, which, according to the msqldumper homepage, is urgently required. I keep getting this message: "There was an error while creating the directory protection !
Please create the 2 files manually with following content". I don't even know which two files it's asking for, unless it wants separate files for the username and the password.

--------------- Added [DATE]1194758587[/DATE] at [TIME]1194758587[/TIME] ---------------

Sorted the situation out through cPanel. Everything is AOK now.

TruthElixirX

11-11-2007 04:58 AM

Quote:

Originally Posted by music legend (Post 1358058)

I'd try resetting counters in the maintenance section of your Admin CP.

Roonie

12-09-2007 01:17 PM

I have used it to move a database from one server to another. I had never been so succesful in restoring a database!

Thanks you very much TruthElixirX

TruthElixirX

12-09-2007 03:17 PM

Quote:

Originally Posted by Roonie (Post 1397881)

I have used it to move a database from one server to another. I had never been so succesful in restoring a database!

Thanks you very much TruthElixirX

Glad I could help. :)

All times are GMT. The time now is 03:37 PM.

Page 2 of 4

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01276 seconds Memory Usage 1,738KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (5)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: