BigKhoj
Member
Posted 2 years ago #
I am new to WordPress. My hosting is providing unlimited mysql databases but of 1gb each. Please any one guide me that what will i do if the 1 gb of my database gets full. My hosting(dreamhost) providing me unlimited databases but i don't know, for the same website(wordpress installation), how to use/add/attach another database if the first one gets full. I really need help !
You can only use 1 database in WordPress.
BigKhoj
Member
Posted 2 years ago #
Thanks esmi, the question is still unsolved, what should one do when that 1 gb gets full, what is possible solution. How people are maintaining huge websites with wordpress. Help me with best solution !
How people are maintaining huge websites with wordpress
They are using hosts that don't limit their database size. Many use their own dedicated server.
If your database is getting towards that size, you could just switch to a different host.
You can only use 1 database in WordPress.
Actually ... Via plugins like SharDB you can use multiple DBs. http://wordpress.org/extend/plugins/shardb/
That said, if your DB really is 1G, I would start by deleting my post revisions and trim them down to 2 or so per post.
http://wordpress.org/support/topic/delete-revisions-or-better-still-prevent-them?replies=8
http://www.drquincy.com/blog/sql-to-delete-all-post-revisions-in-wordpress/
BigKhoj
Member
Posted 2 years ago #
Many Thanks Ipstenu
you really helped with a adequate solution that any expects while posting a question to seek help
.
if you have any more solutions or techniques, you are most welcome...
Thanks