Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

wordpress backups

Posted on 2015-01-04
3
118 Views
Last Modified: 2015-01-06
how can I create multiple wordpress websites using the same database. What are the limitations?

What do I need to backup (files, databases)


I am using shared hosting (and I think there is a limit of databases) for clients paying very little so they really wont care about load time and I just do monthly backups.  Weekly backups if I am using remote mysql to one database will be 10 minutes manually per week.

My problem is I do not think I used table prefix name on the first database, will this affect the others

I do not think the clients will ever want to see the sql file and if they do then I just copy paste the lines with the table prefix

But how do I backup the pictures
0
Comment
Question by:rgb192
3 Comments
 
LVL 4

Accepted Solution

by:
Jernej Navotnik earned 250 total points
ID: 40531116
Dear rgb192,

1. Single database: No limits, just make sure you do not delete any data when you "install" your new wordpress(es)
2. Backup: To backup a website (like wordpress) you need to save the files (the file and folder structure) and the database. And to restore that, you need to copy them back to the same place. The simplest would be that you copy the files via FTP somewhere. Or create a PHP script which packs the files into an archive, exports the database and copies all of this to an desired backup location. And execute the php script in cron, i don't know, once a week (depends on your hosting). Or do this manually. Since you will have multiple sites in a single host, keep your installs  in meaningful subdirectories - so you'll know which site is which.
3. No prefix for the first DB? No problem, but all the others must use one - if you make an mistake, you could overwrite your data from other sites
4. Backup pictures? As i said, copy them using FTP (or if you have some other ways of accessing the server, use some other tools)

But, this is not "the way to go" - I really, truly, must say that I suggest different DB's for different sites, especially that it seems you have not dealt with such scenarios before.
You can lose your data. So, please, always backup, and test your backups - that they can be restored.

Kind regards, Jernej
0
 
LVL 9

Assisted Solution

by:Brandon Lyon
Brandon Lyon earned 250 total points
ID: 40532543
A long time ago Wordpress had a fork named WP-MU (wordpress multi-user). You could use it to create multiple WP sites using the same database. Around version 3 of Wordpress they merged it's functionality into the WP core. You can read more about how to create a WP network here http://codex.wordpress.org/Create_A_Network.
0
 

Author Closing Comment

by:rgb192
ID: 40534726
thanks for wordpress backup ideas
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Read about how to choose the best possible content marketing agency to suit your needs. Content marketing has become an integral part of running a successful tech business, so it is wise to be informed.
These days socially coordinated efforts have turned into a critical requirement for enterprises.
The purpose of this video is to demonstrate how to update a WordPress Site’s version. WordPress releases new versions of its software frequently and it is important to update frequently in order to keep your site secure, and to get new WordPress…
The purpose of this video is to demonstrate how to set up an RSS Feed on a WordPress Website. This will be demonstrated using a Windows 8 PC. Feedburner will be used for this demonstration. Go to your WordPress login page. This will look like the…

766 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question