To login and backup a database in one line:
To restore a database in one line:

I followed step by step the tutorial, SOmehow I might be doing something wrong.

When I imported my very small testing database onto a new server it said it succeeded. When I go into the forum page I expect to see the old members and old threads. Right? After all if I want to transfer my forum onto a new server, then what's the scope of backup.

But in my case NOT. I only see the freshly installed vbulletin on my new server but not the treads and users.

What am I doing wrong?

In just a few words: I want to export my data and transfer it on a new database/server so I won't lose anything from my old forum

That's very useful tutorial .. thanks Snake ...

I'm running a big forum ( DB =~ 2 GB )
and for security I need to know the SSH command that enables me to save a redundant copy of the database their ..
could anyone tell us about their experience in that field ?
And if by chance anyone made a SSH or Linux script or maybe Cron that's automate that process , I hope that I know about it ..

Regards ,

Did you try restoring the database via phpMyAdmin or SSH?

Uhh I'm not really sure what you're talking about.

Hello, please any other split tool DB a part BigDumb? That I tried some month a go
For some reason it dont works good for me, I need to remove some queries from my DB that block the importing process.

I noticed someone asked this question, but it doesn't look like it got answered. Anyway, the MySQL command could be more complete. In some cases the server might not be localhost. Therefore, the command should look like this:

mysql -u MyUserName -p MyDBName -h mysql.myhost.com < /full/path/to/sqldump.sql

thanks for post

for those with SSH access its very easy to backup and to compress (gzip took my DB from 1.4GB to 327MB - Took about 3 minutes

mysqldump --opt -Q -u <username> -p <database name> | gzip > database.sql.gz

to restore....

gunzip < database.sql.gz | mysql -u <username> -p <database name>

hope this is clear and helps someone out

Yeah, but I don't think most of the hosts out there provide SSH access especially when they're running a small forum. That's why the either way to backup and/or restore is by phpMyAdmin or some other SQL tool. Shell is pretty much useful for a very large forum.

You're quite welcome, letsjoy.

How does bash/command line. look like or what is it???

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 :(

thanks

I use This Command But Server Says Me

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?

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?

my be use scrip like bigdump.php