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,084
The Queen of DaniWeb Administrator Featured Poster Premium Member
Recommended Answers
Jump to Post(she's using mysqldump)
take a look at
http://www2.yo-linux.com/cgi-bin/man.cgi?topic=mysqldump
Jump to Posti wouldnt suggest using vb's mysql dump feature either
ive used the ssh mysql dumb quite a fewq times just finemysqldump --opt -uUSERNAME -pPASSWORD databasname > /path/to/dump.sql
i honestly never had a problem with it
vb also has a specific table backup if …
Jump to PostRTFM ;-) From the man page linked above:
--opt Same as --add-drop-table --add-locks --all
--extended-insert --quick --lock-tables
All 12 Replies
evilmonkey29 0
Junior Poster in Training
MGM 0
Light Poster
Dani 4,084
The Queen of DaniWeb Administrator Featured Poster Premium Member
Zachery 43
The Geek Father Team Colleague
Dani 4,084
The Queen of DaniWeb Administrator Featured Poster Premium Member
MGM 0
Light Poster
Tekmaven 258
Software Architect Team Colleague
floris 104
Junior Poster
Dani 4,084
The Queen of DaniWeb Administrator Featured Poster Premium Member
mikeSQL 5
Junior Poster
Gary King 37
PHP/vBulletin Guru Team Colleague
igotdreams 0
Newbie Poster
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.