Free databases?

1

My service provider is web-mania.com

they only give you one database with their hosting packages. However I am using wordpress and have two domains on my hosting package. Seeing as each wordpress site requires its own database is there a way of getting a free one? web mania have told me that they cant give me another one :frowning:

anyone have any ideas?

Billy

2

Look at free host that offer mysql :D, then you will be able to use that for your site.

3

Make 2 prefix’s

domain 1 can be

wp_

and domain 2 can be

pw_

4

^

Wordpress installations can share databases.

5

^woudl you nto then have to change the files to have the pw_ for the second on or?

6

could you guys elaborate? im not experienced with mySQL. thanks

7

Okay.

Databases are like folders. In each database, you can have infinitely many tables. A table is exactly what it is - it’s rows of data, each with data for the columns specified by the table structure.

A WordPress installation needs a few tables in one database. However WordPress developers realize that sometimes you only have one database, so they made WordPress support a prefix for all the tables needed for that installation of WordPress. For that one installation, WordPress will create tables, with a certain prefix, e.g. “wp_” (this is the default).

That way, you can install more than 1 instance of WordPress in one database, by having different prefixes so each WordPress installation recognizes its own tables. For that second installation of WordPress, you can have any prefix that’s different from the first.

The prefixes are set in the wp-config.php file in the root folder of the WordPress installation. The default there is “wp_”. Change it to whatever, upload it, install it. For the second installation, change it to something else, upload it to another folder, install it. Everything will work as intended.

8

ah thats great. thanks MT, great explanation! :smiley:

9

You are welcome :slight_smile: