You are missing our premiere tool bar navigation system! Register and use it for FREE!

NukeCops  
•  Home •  Downloads •  Gallery •  Your Account •  Forums • 
Readme First
- Readme First! -

Read and follow the rules, otherwise your posts will be closed
Modules
· Home
· FAQ
· Buy a Theme
· Advertising
· AvantGo
· Bookmarks
· Columbia
· Community
· Donations
· Downloads
· Feedback
· Forums
· PHP-Nuke HOWTO
· Private Messages
· Search
· Statistics
· Stories Archive
· Submit News
· Surveys
· Theme Gallery
· Top
· Topics
· Your Account
Who's Online
There are currently, 349 guest(s) and 0 member(s) that are online.

You are Anonymous user. You can register for free by clicking here
Nuke Cops :: View topic - How big is your database? [ ]
 Forum FAQ  •  Search  •   •  Memberlist  •  Usergroups   •  Register  •  Profile •    •  Log in to check your private messages  •  Log in

 
Post new topic  Reply to topicprinter-friendly view
View previous topic Log in to check your private messages View next topic
Author Message
steven111
Lieutenant
Lieutenant


Joined: Dec 30, 2003
Posts: 283


PostPosted: Mon Oct 04, 2004 9:00 pm Reply with quoteBack to top

OCSupertones wrote:
Is there a better way to backup than with the admin panel?


The other way is to directly TAR the mysql directory. This is my preferred approach for batch backups.

Here is a thread.

http://www.webhostingtalk.com/showthread.php?s=&threadid=229372&highlight=tar+mysql+backup

_________________
ezClassifieds|Forums:Auto,Mac,Job,Win,HW
Find all posts by steven111View user's profileSend private messageVisit poster's website
Dynamics
Nuke Soldier
Nuke Soldier


Joined: Sep 28, 2004
Posts: 11


PostPosted: Tue Oct 05, 2004 4:59 am Reply with quoteBack to top

Yes that is an excellent way to backup and restore from the shell, and there is even a way to put this command into php using the system() php command.
Find all posts by DynamicsView user's profileSend private messageSend e-mail
swagster
Nuke Soldier
Nuke Soldier


Joined: Sep 16, 2004
Posts: 10


PostPosted: Mon Oct 11, 2004 5:59 am Reply with quoteBack to top

mine is over 600Mb... the nuke admin backup or php my admin won't work well because of the size.

The best way is via ssh using Putty. Here's the process:::::


If you have access to SSH (or telnet will work, though use ssh not telnet as ssh is encrypted) you can do everything you need to right from the command line.

to get a dump of you db, connect with ssh, then you simply need to type:
mysqldump -u yourMysqlUsername -p DBNAME > filename.sql (hit enter)
you will then be prompted for your password

you are done Smile there should now be a file called filename.sql with all your structure and data.

Alternate syntax:
mysqldump -u yourMysqlUsername -pPASSWORD DBNAME > filename.sql (hit enter)
(the no space between -p and PASSWORD is not a typo)

mysqldump --user=yourMysqlUsername --password=PASSWORD DBNAME > filename.sql (hit enter)

you can also add more db names on and dump more then one at a time, but I think one at a time is better. one db per file that way.
Find all posts by swagsterView user's profileSend private message
Akaveli
Captain
Captain


Joined: Jan 03, 2004
Posts: 501


PostPosted: Tue Apr 05, 2005 9:04 am Reply with quoteBack to top

3.08 MB Laughing
Find all posts by AkaveliView user's profileSend private message
canadaka
Corporal
Corporal


Joined: Aug 05, 2004
Posts: 71

Location: Vancouver, Canada

PostPosted: Tue Apr 18, 2006 10:57 pm Reply with quoteBack to top

www.canadaka.net/forums

345.89 MB
Find all posts by canadakaView user's profileSend private messageVisit poster's website
arnoldkrg
Major
Major


Joined: Aug 03, 2003
Posts: 936

Location: United Kingdom

PostPosted: Tue Apr 18, 2006 11:30 pm Reply with quoteBack to top

I just backed up a 120Mb database. Using phpMyAdmin, trying to save the file as a zipped or gzipped file didnt work. However I was able to download the uncompressed file. BUT phpMyAdmin would not allow me to reinstall such a big database. I used bigdump and was able to reinstall with no problems.

_________________
Image
Find all posts by arnoldkrgView user's profileSend private messageSend e-mailVisit poster's website
athens101
Sergeant
Sergeant


Joined: Jul 11, 2004
Posts: 104

Location: Athens

PostPosted: Fri Jan 19, 2007 10:06 am Reply with quoteBack to top

I am glad we decided to host our site from home. Looks like it can be a pain to backup from a host.

I use phpmyadmin for the backup and it's about 85mb. To restore I sftp intot he server and dump the sql file in the root dir then ssh and restore from.
Find all posts by athens101View user's profileSend private messageVisit poster's website
Slackervaara
Captain
Captain


Joined: Sep 13, 2003
Posts: 355


PostPosted: Fri Jan 19, 2007 5:27 pm Reply with quoteBack to top

My backup is 21 MB, but gzipped. I use MySQLDumper, both for backup and restore. It is ideally suited for large backups like mine.

http://www.mysqldumper.de/en/
Find all posts by SlackervaaraView user's profileSend private message
_ddog_
Nuke Cadet
Nuke Cadet


Joined: Feb 19, 2007
Posts: 1


PostPosted: Sun Feb 18, 2007 9:19 pm Reply with quoteBack to top

after reading on this mine is pretty small 5.9mb zipped lol
Find all posts by _ddog_View user's profileSend private message
bigtree
Sergeant
Sergeant


Joined: Feb 04, 2004
Posts: 100


PostPosted: Mon Feb 19, 2007 8:36 am Reply with quoteBack to top

mine is pretty large as well (450 MB) PHPnuke and my server aren't handleing the size well.
Find all posts by bigtreeView user's profileSend private message
Display posts from previous:      
Post new topic  Reply to topicprinter-friendly view
View previous topic Log in to check your private messages View next topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2005 phpBB Group

Ported by Nuke Cops © 2003 www.nukecops.com
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::
Powered by TOGETHER TEAM srl ITALY http://www.togetherteam.it - DONDELEO E-COMMERCE http://www.DonDeLeo.com - TUTTISU E-COMMERCE http://www.tuttisu.it
Web site engine's code is Copyright © 2002 by PHP-Nuke. All Rights Reserved. PHP-Nuke is Free Software released under the GNU/GPL license.
Page Generation: 0.038 Seconds - 232 pages served in past 5 minutes. Nuke Cops Founded by Paul Laudanski (Zhen-Xjell)
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::