# Free databases? **URL:** \ **Category:** Uncategorized\ **Created:** [April 16, 2006, 6:03pm UTC](https://forum.kirupa.com/t/free-databases/185801 "2006-04-16T18:03:44Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![billystar](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/billystar/32/9258_2.png) [@billystar](https://forum.kirupa.com/u/billystar)\ **Post date:** [April 16, 2006, 6:03pm UTC](https://forum.kirupa.com/t/free-databases/185801/1 "2006-04-16T18:03:44Z")
My service provider is [web-mania.com](http://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 ☹ anyone have any ideas? Billy ---
**Author:** ![Seb\_Hughes](https://avatars.discourse-cdn.com/v4/letter/s/839c29/32.png) [@Seb\_Hughes](https://forum.kirupa.com/u/Seb_Hughes)\ **Post date:** [April 16, 2006, 6:16pm UTC](https://forum.kirupa.com/t/free-databases/185801/2 "2006-04-16T18:16:50Z")
Look at free host that offer mysql :D, then you will be able to use that for your site. ---
**Author:** ![idoik](https://avatars.discourse-cdn.com/v4/letter/i/97f17d/32.png) [@idoik](https://forum.kirupa.com/u/idoik)\ **Post date:** [April 16, 2006, 6:24pm UTC](https://forum.kirupa.com/t/free-databases/185801/3 "2006-04-16T18:24:21Z")
> [@billystar](#): > > My service provider is [web-mania.com](http://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 ☹ > > anyone have any ideas? > > Billy Make 2 prefix’s domain 1 can be wp\_ and domain 2 can be pw\_ ---
**Author:** ![MTsoul](https://avatars.discourse-cdn.com/v4/letter/m/91b2a8/32.png) [@MTsoul](https://forum.kirupa.com/u/MTsoul)\ **Post date:** [April 16, 2006, 6:46pm UTC](https://forum.kirupa.com/t/free-databases/185801/4 "2006-04-16T18:46:01Z")
^ Wordpress installations can share databases. ---
**Author:** ![Seb\_Hughes](https://avatars.discourse-cdn.com/v4/letter/s/839c29/32.png) [@Seb\_Hughes](https://forum.kirupa.com/u/Seb_Hughes)\ **Post date:** [April 16, 2006, 7:06pm UTC](https://forum.kirupa.com/t/free-databases/185801/5 "2006-04-16T19:06:54Z")
^woudl you nto then have to change the files to have the pw\_ for the second on or? ---
**Author:** ![billystar](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/billystar/32/9258_2.png) [@billystar](https://forum.kirupa.com/u/billystar)\ **Post date:** [April 16, 2006, 7:07pm UTC](https://forum.kirupa.com/t/free-databases/185801/6 "2006-04-16T19:07:00Z")
could you guys elaborate? im not experienced with mySQL. thanks ---
**Author:** ![MTsoul](https://avatars.discourse-cdn.com/v4/letter/m/91b2a8/32.png) [@MTsoul](https://forum.kirupa.com/u/MTsoul)\ **Post date:** [April 16, 2006, 7:17pm UTC](https://forum.kirupa.com/t/free-databases/185801/7 "2006-04-16T19:17:05Z")
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. ---
**Author:** ![billystar](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/billystar/32/9258_2.png) [@billystar](https://forum.kirupa.com/u/billystar)\ **Post date:** [April 16, 2006, 7:31pm UTC](https://forum.kirupa.com/t/free-databases/185801/8 "2006-04-16T19:31:31Z")
ah thats great. thanks MT, great explanation! 😃 ---
**Author:** ![MTsoul](https://avatars.discourse-cdn.com/v4/letter/m/91b2a8/32.png) [@MTsoul](https://forum.kirupa.com/u/MTsoul)\ **Post date:** [April 16, 2006, 7:35pm UTC](https://forum.kirupa.com/t/free-databases/185801/9 "2006-04-16T19:35:29Z")
You are welcome 🙂