do I need multiple installations? do I need 2 databases?

  • Hi,
    I have a question which is not yet a problem ??
    I have a blog that in in italian and will have a mirror in english on a subdomain (eng.myblog.com) and both will have also a mobile version (mobile.myblog.com).

    What I’m asking is if I need more then one database.

    I don’t know much about databases, but I assume that the italian blog and its mobile version can stay on the same database because the content is the same, I’m basically just switching theme.

    the same goes for the english mirror. However I guess I can’t keep the english and the italian blog on the same db coz the content will be different. for instance if I use a query collecting the last 5 articles in the italian blog but I share the database with the english blog it will retrieve articles in both languages.
    Is that right?

    do I need 2 databases?

    Please, if you have any suggestion you’re welcome. it’s the last step before going live and I can’t wait ??

    Thanks!

Viewing 7 replies - 1 through 7 (of 7 total)

  • do I need 2 databases?

    No, you can use the same db and just have separate tables for each blog. See the following video for the details.

    https://educhalk.org/blog/?p=34

    Thread Starter M1chel

    (@m1chel)

    Thanks mate!
    it really looks like you solved my problem.

    So let me get this straight: copying an existing installation I only have to modify the config file changing the table prefix and the blog will automatically create its own tables inside my database. so things won’t mess up.
    right?

    and it makes no difference that I’ll be saving those installations on different subdomains as long the config is the same and direct all to the same database, right?

    Right and right.

    Thread Starter M1chel

    (@m1chel)

    Great!
    thank you so much and keep up the good work on your site, that tutorial is fantastic.

    You’re welcome.

    Thread Starter M1chel

    (@m1chel)

    hey, since we’re here and I assume you have a long experience on wordpress maybe you can help me with another small problem.
    I created a custom 404 page that I saved as 404.php but when I try a fake url I get the standard ugly page and not mine.
    I haven’t found any place in wordpress to change this settings so reading some guides and stuff I understood I had to add ErrorDocument 404 https://localhost/wordpress/wp-content/themes/default/404.php to the .htaccess file.
    It worked.
    However the page doesn’t respond to the tags get_header and get_footer.
    It’s like the 404.php isn’t part of the theme, it doesn’t retrieve the other parts.
    Do you know why?

    I opened a topic about this a couple of days ago but no one answered, so I’m asking to you if you have any suggestions..
    https://www.ads-software.com/support/topic/294640?replies=1

    Thread Starter M1chel

    (@m1chel)

    Hi, I have to bring this up again coz now I’m trying to set up the subdomains of my blog and I’m experiencing problems.

    I have myblog.com where I installed wordpress.
    I have a subdomain mob.myblog.com which is the mobile version and it should use the same db, just a different theme.

    I have eng.myblog.com e eng.mob.myblog.com which are the english version of my blog with its moble version. they will have a different table in the database because they’ll have posts in english.

    I installed wordpress on the main domain and I copied the installation in the mobile subdomain with the same db prefix coz they’ll have the same posts, but when I login to mob.myblog.com/wp-admin/ I get redirected to myblog.com/wp-admin/ and I think I can’t change theme without influencing also the main domain. how I solve this?

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘do I need multiple installations? do I need 2 databases?’ is closed to new replies.