vb.org Archive - Backup/restore using phpMyAdmin/SSH

Page 6 of 6

« First

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 using phpMyAdmin/SSH (https://vborg.vbsupport.ru/showthread.php?t=106935)

nickson

07-29-2009 10:29 AM

my host has 2mb of limited to upload sql, and my database is worth 22mb, how could i go about this now? I am noob for restoring :(

dr.msk

11-08-2009 06:51 PM

thanks

kabir

03-03-2010 07:04 AM

Quote:

Originally Posted by Coders Shack (Post 1248567)

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 This Command But Server Says Me

Quote:

gsmrapid@gsmrapid.com [~]# mysql --password=bH>-cgSlQ9d/ -h localhost -u gsmrapid_forum gsmrapid_forum < gsmrapid_forum.sql
-jailshell: -cgSlQ9d/: Is a directory
gsmrapid@gsmrapid.com [~]#

ehabfouad22

03-06-2010 07:25 PM

I've created a backup zipped file in (MYI, MYD, FRM) formats. Its size was about 120 MB. Then I created a backup of the same database through phpMyAdmin in a .sql format, with a size of 16 MB only! Does that mean that my backup with phpMyAdmin was incomplete? Or it's normal to have a .sql file with a size much less than the actual size of direct database files?

basketmen

09-21-2010 08:56 AM

guys i want to move to another host, i already backup the mysql using ssh and get the .sql file, downloading to computer, and i want to uploading to new host using ftp and restore it there using ssh too

my question is in uploading to new host using ftp part, do i need using ASCII mode or binary mode when uploading the .sql file?

almajrouh

11-27-2010 08:15 AM

my be use scrip like bigdump.php

All times are GMT. The time now is 12:03 AM.

Page 6 of 6

« First

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05313 seconds Memory Usage 1,724KB 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 (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (6)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: