Certain graphical elements in this forum (such as user's avatars and file attachments) are actually stored in the database instead of in the file system. Is there a way to back these up along with the database? For example, when I make an sql dump file, it obviously doesn't export these elements.
Dani 4,312 The Queen of DaniWeb Administrator Featured Poster Premium Member
evilmonkey29 0 Junior Poster in Training
MGM 0 Light Poster
mysqldump? you know, vBulletin has an integrated backup system that automatically backs up attachements and images. Also, why not use phpMyAdmin? I use it and find it tons helpful in backing things up (although I prefer using vBulletin's method better)
MGM out
Dani 4,312 The Queen of DaniWeb Administrator Featured Poster Premium Member
I've since got it to work via mysqldump. I've found that phpMyAdmin isn't very reliable and often times out when dumping a large database. In addition, I needed a cli command because I wanted to make it into a cron job ;) for automatic nightly database back-up.
Thanks for your help :)
Zachery 43 The Geek Father Team Colleague
i wouldnt suggest using vb's mysql dump feature either
ive used the ssh mysql dumb quite a fewq times just fine
mysqldump --opt -uUSERNAME -pPASSWORD databasname > /path/to/dump.sql
i honestly never had a problem with it
vb also has a specific table backup if you backup the full DB, anything store in the DB will be backuped as well
Dani 4,312 The Queen of DaniWeb Administrator Featured Poster Premium Member
Faranth, I use the same command as you without the --opt - what does that do?
MGM 0 Light Poster
yes, in testing my forums on my private server, ive used ssh and ran a command like that, and what cscgal said, whats --opt????
MGM out
Tekmaven 258 Software Architect Team Colleague
RTFM ;-) From the man page linked above:
--opt Same as --add-drop-table --add-locks --all
--extended-insert --quick --lock-tables
floris 104 Junior Poster
vb3 lets you store the attachments and avatars on the file system rather then database system. You might want to look into this :)
Dani 4,312 The Queen of DaniWeb Administrator Featured Poster Premium Member
Certain graphical elements in this forum (such as user's avatars and file attachments) are actually stored in the database instead of in the file system.
In any case, I was able to get the problem fixed now. I was having a hard time saving binary representing the graphics, etc into the mysql dump. All fixed :) Sorry for not notifying everyone. I forgot all about this thread.
mikeSQL 5 Junior Poster
Then come again, you can easily do it through your CPanel if your running 1. Itlll backup your entire disk including files. Easy to use for export and import I shld say, butthtsanother catigory. Or is it?
Gary King 37 PHP/vBulletin Guru Team Colleague
This is a very old thread, no point in replying 11 months later :(
igotdreams 0 Newbie Poster
This is a very old thread, no point in replying 11 months later :(
I will reply because someone will have the same problem.
I use a program called MySqlMaestro, it can backup data or structure or both. It is way better than phpmyadmin and you will shoot yourself not knowing it existed. It is very good, man I should be an affiliate.
Here is the link;
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.