I am not quite sure how best to setup a local Drupal development server. This is only for developing the websites, which when ready for publishing will be migrated to the hosting server.
Still at the planning stage with all this, I want to keep each website separate. So I was thinking of having separate MySQL users, each with their own MySQL database. Also, I am not sure where to save (physically) each database. Is it prudent to keep them separately under the respective virtual host domainname fs (/var/www/<domainname>), or should I leave these under the default /var/lib/mysql/, or where ever they are normally stored? Haven't looked into tablespaces yet. For the sake of avoiding a major domestic, I want to make sure that migration to the hosting server will happen without any glitches, or worse having to redesign the website from scratch! What's a clever way of going about this? -- Regards, Mick
signature.asc
Description: This is a digitally signed message part.

