WordPress.org

Support

PhpMyAdmin

  • 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)
  • Mark (podz)

    @podz

    Support Maven

    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.

    thanks for that podz i’ll try my best 😛

    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

    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

    — 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 🙂

    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

    gb2000, how exactly do you access your database at your host? What tool(s) do they provide?

    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 ?

    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.

    Thanks 2fargon but how do i edit wp-config.php file to include more databases 🙂 .

    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.

    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.

    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.

    Thanks 2fargon i’ll let you know how i getting along 🙂

    So i just change this ‘wp_’; to this ‘wp2_’; ? Then i get two tables within the same database ?

    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)
  • The topic ‘PhpMyAdmin’ is closed to new replies.