WordPress.org

Forums

PhpMyAdmin (17 posts)

  1. gingerbeer2000
    Member
    Posted 10 years ago #

    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

  2. Mark (podz)
    Support Maven
    Posted 10 years ago #

    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.

  3. gingerbeer2000
    Member
    Posted 10 years ago #

    thanks for that podz i'll try my best :P

  4. gingerbeer2000
    Member
    Posted 10 years ago #

    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

  5. theboywonder
    Member
    Posted 10 years ago #

    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 :)

  6. gingerbeer2000
    Member
    Posted 10 years ago #

    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

  7. Kafkaesqui

    Posted 10 years ago #

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

  8. gingerbeer2000
    Member
    Posted 10 years ago #

    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 ?

  9. carthik
    Member
    Posted 10 years ago #

    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.

  10. gingerbeer2000
    Member
    Posted 10 years ago #

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

  11. carthik
    Member
    Posted 10 years ago #

    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.

  12. gingerbeer2000
    Member
    Posted 10 years ago #

    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.

  13. carthik
    Member
    Posted 10 years ago #

    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.

  14. gingerbeer2000
    Member
    Posted 10 years ago #

    Thanks 2fargon i'll let you know how i getting along :)

  15. gingerbeer2000
    Member
    Posted 10 years ago #

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

  16. kri
    Member
    Posted 10 years ago #

    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.

  17. gingerbeer2000
    Member
    Posted 10 years ago #

    thanks kri :)

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.