Title: PhpMyAdmin Last modified: August 18, 2016 --- # PhpMyAdmin * [gingerbeer2000](https://wordpress.org/support/users/gingerbeer2000/) * (@gingerbeer2000) * [21 years, 3 months ago](https://wordpress.org/support/topic/phpmyadmin-1-2/) * I know the following things * Database Name Username Hostname MySql Password * If i installed PhpMyAdmin on my local machine how would i set above information and at the same time download the database on my online server to my desktop ? * Thanks in advance Viewing 15 replies - 1 through 15 (of 16 total) 1 [2](https://wordpress.org/support/topic/phpmyadmin-1-2/page/2/?output_format=md) [β†’](https://wordpress.org/support/topic/phpmyadmin-1-2/page/2/?output_format=md) * [Mark (podz)](https://wordpress.org/support/users/podz/) * (@podz) * [21 years, 3 months ago](https://wordpress.org/support/topic/phpmyadmin-1-2/#post-156336) * If you are after a mirrored setup of your site, I would recommend downloading xampp. One click installer. Drop your blog file into /htdocs Import your .sql export into a db using phpmyadmin (which comes with xampp) and you should be good to go. * Thread Starter [gingerbeer2000](https://wordpress.org/support/users/gingerbeer2000/) * (@gingerbeer2000) * [21 years, 3 months ago](https://wordpress.org/support/topic/phpmyadmin-1-2/#post-156338) * thanks for that podz i’ll try my best πŸ˜› * Thread Starter [gingerbeer2000](https://wordpress.org/support/users/gingerbeer2000/) * (@gingerbeer2000) * [21 years, 3 months ago](https://wordpress.org/support/topic/phpmyadmin-1-2/#post-156553) * Everything is running ok atm and i have created a same user name and password to my online site. I need to know how can i download the online database to my pc and create additional databases for the new user ? * Thanks in advance * [theboywonder](https://wordpress.org/support/users/theboywonder/) * (@theboywonder) * [21 years, 3 months ago](https://wordpress.org/support/topic/phpmyadmin-1-2/#post-156570) * I’ve recently just done this too πŸ™‚ * Easiest way: * 1: Login to phpMyAdmin on your current webhost. 2: Select the wordpress database from the right hand menu 3: Click EXPORT * 4: Make sure the following options are ticked Structure (ticked) – Add AUTO_INCREMENT value (ticked) – Enclose table and field names with backquotes (ticked) * Data (ticked) – Use hexadecimal for binary fields (ticked) * 5. No compression 6. Click go! You’ll get output similar to the following: * β€” phpMyAdmin SQL Dump β€” version 2.6.1 β€” [http://www.phpmyadmin.net](http://www.phpmyadmin.net)β€”β€” Host: localhost β€” Generation Time: Feb 28, 2005 at 10:29 PM β€” Server version: 4.1.10 β€” PHP Version: 5.0.3 β€” β€” Database: `wordpresshome` β€” * β€” ——————————————————– * β€” β€” Table structure for table `wp_categories` β€” * CREATE TABLE `wp_categories` ( `cat_ID` bigint(20) NOT NULL auto_increment, ………… etc * 7. Copy everything from CREATE_TABLE to the end. 8. Using phpMyAdmin on your home server, create a new database. Select it, and click β€œSQL” and paste the text into the window. 9. Click go! This will import your database πŸ™‚ * Thread Starter [gingerbeer2000](https://wordpress.org/support/users/gingerbeer2000/) * (@gingerbeer2000) * [21 years, 3 months ago](https://wordpress.org/support/topic/phpmyadmin-1-2/#post-156598) * That sounds good but i dont have phpMyAdmin on the online webhost, only installed on the local machine. Would i need to install it on my webhost if so how ? THanks * [Kafkaesqui](https://wordpress.org/support/users/kafkaesqui/) * (@kafkaesqui) * [21 years, 3 months ago](https://wordpress.org/support/topic/phpmyadmin-1-2/#post-156600) * gb2000, how exactly do you access your database at your host? What tool(s) do they provide? * Thread Starter [gingerbeer2000](https://wordpress.org/support/users/gingerbeer2000/) * (@gingerbeer2000) * [21 years, 3 months ago](https://wordpress.org/support/topic/phpmyadmin-1-2/#post-156700) * When i first installed WP on my host i knew the mysql password &username details so i managed by luck maybe to create a database for my blog. * But if i wanted to backup or create multiple databases how can i acheive this with no phpMyadmin installed on my host ? * [carthik](https://wordpress.org/support/users/carthik/) * (@carthik) * [21 years, 3 months ago](https://wordpress.org/support/topic/phpmyadmin-1-2/#post-156701) * You can use the same database, with different table prefixes (definable in the wp-config.php file) to have different blogs use the same database. * A man only needs one database, like a man only needs one email client πŸ™‚ * To backup your wp database, use the one-click backup and restore plugin, which you can search on google to find. * Thread Starter [gingerbeer2000](https://wordpress.org/support/users/gingerbeer2000/) * (@gingerbeer2000) * [21 years, 3 months ago](https://wordpress.org/support/topic/phpmyadmin-1-2/#post-156702) * Thanks 2fargon but how do i edit wp-config.php file to include more databases πŸ™‚ . * [carthik](https://wordpress.org/support/users/carthik/) * (@carthik) * [21 years, 3 months ago](https://wordpress.org/support/topic/phpmyadmin-1-2/#post-156703) * What is that you want to do? * For one wordpress blog, one database is good enough, there is no need to add any more databases. * If you want to create a new blog that uses the same database, change the table prefix in wp-config.php (to, say, β€˜wp2’ instead of the default β€˜wp’). * But it depends on why you are wanting to create more than one database. So please explain why and I will try my best to answer you. * Thread Starter [gingerbeer2000](https://wordpress.org/support/users/gingerbeer2000/) * (@gingerbeer2000) * [21 years, 3 months ago](https://wordpress.org/support/topic/phpmyadmin-1-2/#post-156705) * I want to create another 3 sites that have WP installed and access to the seperate databases, can i use the same database but like you said different tables within the database linked to the seperate web blogs ? If so how can i acheive this thanks. * [carthik](https://wordpress.org/support/users/carthik/) * (@carthik) * [21 years, 3 months ago](https://wordpress.org/support/topic/phpmyadmin-1-2/#post-156706) * Yes, For your second wp powered blog, edit wp-config.php and use the same database, username, password etc as you did for your first wp blog. In addition, find the lines that say: ` // Change the prefix if you want to have multiple blogs in a single database. $table_prefix = 'wp_'; // example: 'wp_' or 'b2' or 'mylogin_' and edit the line to // Change the prefix if you want to have multiple blogs in a single database. $table_prefix = 'wp2_'; // example: 'wp_' or 'b2' or 'mylogin_' You can have any number of blogs on the same database, all you need to do is to edit the wp-config.php file to have a different $table_prefix value, for each blog. * Thread Starter [gingerbeer2000](https://wordpress.org/support/users/gingerbeer2000/) * (@gingerbeer2000) * [21 years, 3 months ago](https://wordpress.org/support/topic/phpmyadmin-1-2/#post-156710) * Thanks 2fargon i’ll let you know how i getting along πŸ™‚ * Thread Starter [gingerbeer2000](https://wordpress.org/support/users/gingerbeer2000/) * (@gingerbeer2000) * [21 years, 3 months ago](https://wordpress.org/support/topic/phpmyadmin-1-2/#post-156712) * So i just change this β€˜wp_’; to this β€˜wp2_’; ? Then i get two tables within the same database ? * [kri](https://wordpress.org/support/users/kri/) * (@kri) * [21 years, 3 months ago](https://wordpress.org/support/topic/phpmyadmin-1-2/#post-156714) * Yes, that’s what that little piece is for. It allows you to have two wordpress installs on one site/one database. If you were able to look at your database once you have the two wordpress’s installed, it would show you tables like such.. wp_categories, wp_comments, wp_exhibit, etc and wp2_categories, wp2_comments, etc. Viewing 15 replies - 1 through 15 (of 16 total) 1 [2](https://wordpress.org/support/topic/phpmyadmin-1-2/page/2/?output_format=md) [β†’](https://wordpress.org/support/topic/phpmyadmin-1-2/page/2/?output_format=md) The topic β€˜PhpMyAdmin’ is closed to new replies. * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) * 16 replies * 6 participants * Last reply from: [gingerbeer2000](https://wordpress.org/support/users/gingerbeer2000/) * Last activity: [21 years, 3 months ago](https://wordpress.org/support/topic/phpmyadmin-1-2/page/2/#post-156715) * Status: not resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics