Creation Dump of Database with phpMyAdmin

[rondelw]

As per Dave Baker's suggestion, I'm writing to find out how to create a database with phpMyAdmin. My webhosting is cpanel. I'm basically new to this and don't know anything about it. I've never been exposed to phpMyAdmin. What's my first step or a good resource to start with?

Thanks in advance...

[Dave Baker]

Open phpMyAdmin ->Export->Choose necessary database ->Choose necessary structure of saving-> Mark to save in a file -> And press button "GO"

[rondelw]

Okay...I will try this...it'll take me a day or two because I am doing a community directory that I need to make all my categories and then export...but say I wanted to start a new site with a new theme that had new categories, can I use myphpadmin to build it from the ground up prior to adding any links?

[Vincent Wright]

You can export your categories from existing site as suggested by Dave and then import them into new site.

[rondelw]

You know, I was hoping to be able to just create a shell of a database and import it without exporting...I bought the unlimited site version so I could use this script on several different sites for several different reasons...some being link directories others being link exchanges...many of the sites will have different categories so I will probably just get buy making the cats & subcats manually...thanks for your help...you guys are great

[Vincent Wright]

You are welcome!

[Dave Baker]

You are welcome :)

[rondelw]

Well I decided to go for it...I deleted a text file that came out titled as localhost.txt I tried to import that in my new site and I recieved an error message that said the database of the file I exported from didn't exists...so I opened the file and changed the name of the database to the name of the one that I want to import the categories into. This is the error I recieved:
Error

SQL query:

-- phpMyAdmin SQL Dump
-- version 2.8.0.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 25, 2006 at 07:20 PM
-- Server version: 4.1.19
-- PHP Version: 4.4.2
--
-- Database: `dixondir_links`
--
CREATE DATABASE `dixondir_links` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

MySQL said: Documentation
#1007 - Can't create database 'dixondir_links'; database exists


any thoughts?

[dynn]

how to upload the ready sql dump category that i download from the download section?

[Simon Gooffin]

CREATE DATABASE `dixondir_links` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

MySQL said: Documentation
#1007 - Can't create database 'dixondir_links'; database exists

any thoughts?
Hi,
You should not create a dump with structure. Just create a dump of your data. Now you can do the following. Simply drop your links table and try again.

how to upload the ready sql dump category that i download from the download section?
Please upload it to your 'updates' directory. Login as admin then click manage database -> import. Choose it from a list and click go.
That's all