SQL from one datbase to another

“Got an error.”

What exactly ?

sorry, I should of mention that. also, maybe I should mention I’m using phpmyadmin to try to do this. When I go to the new database I click on the SQL tab and use the function to browse and locate the sql file. Here is the error I get (I copied and pasted it).

Error
SQL query:

— phpMyAdmin SQL Dump
— version 2.6.4-pl2
— https://www.phpmyadmin.net
—
— Host: localhost
— Generation Time: Dec 20, 2005 at 09:24 AM
— Server version: 4.0.16
— PHP Version: 4.3.11
—
— Database: filipina_press
—
— ——————————————————–
—
— Table structure for table wp_categories
—
CREATE TABLE wp_categories (

cat_ID bigint( 20 ) NOT NULL AUTO_INCREMENT ,
cat_name varchar( 55 ) NOT NULL default ”,
category_nicename varchar( 200 ) NOT NULL default ”,
category_description longtext NOT NULL ,
category_parent int( 4 ) NOT NULL default ‘0’,
PRIMARY KEY ( cat_ID ) ,
KEY category_nicename ( category_nicename )
) TYPE = MYISAM AUTO_INCREMENT =5
MySQL said:

#1050 – Table ‘wp_categories’ already exists

“created a new database and installed WordPress again in this new directory.”

Create database.
Do NOT install WP, just import the db.
To cure:
– DROP the tables in the db
– Import your sql ??

While exporting you may have omitted the following options in structure:

Add DROP TABLE
Add IF NOT EXIST
…

When you install wordpress it creates empty tables.
You should “drop” them and insert your old data instead.

Podz…not sure I get your comment.

I have to intall a fresh copy of WordPress to eliminate the error i keep getting.

Doesn’t dropping a database delete it. That seems dangerous. What happens if I don’t get it to import properly in the new database…gulp!

I don’t see any import function in phpmyadmin. I see an export tab, but nothing about importing a database. The only thing I found close is under the SQL tab which has a function to browse for a sql file which I used to browse for the sql file I exported.

Help please….sorry guys, my knowledge of sql is limited.

https://www.tamba2.org.uk/wordpress/
On the right there will be a guide that covers what you need.
Your sql file. Copy it. Keep the original. Work off the copy.

Thanks podz for your efforts. I read you info on your site (very nice site by the way), but nothing seems to work. This all started with that darn Precondition Failure errro and after two weeks of trying to get it resolved I’m mentally exhausted.

I hate the thought, but maybe I need to look for another blog program. I would hate the thought of reinstalling WordPress again, copying it over to new installation and down the road this same error popus up again. I know, no guarantees, but with my little knowledge, not sure what else to do.

thanks for your efforts. it was appreciated.

steve

I can import the db for you and get that working. As for the error – that could be anywhere from your ISP’s cache and further. It is not always your browser. Has your ISP got a suport number / forums ?

Wow Podz…you are fantastic…hope this pays off for someone else besides me.

Well, I didn’t give up. Did more searching and this time I got the exported database to execute in the new database without error. Man, I thought great.

Then I typed the new directory in the browser and it came up a blank page….hmmmmmmm.

No errors, just a blank page instead of the WordPress home page/index page. I’m sure the right tweaking would fix it. Any idea what it is?

thanks again
steve

p.s. I battled my host about the Precondition failure error….they don’t seem to care nor will they help.

Blank page – try changing the theme ?

Yep, sometimes happens if you forget to set the theme back to default before exporting the database….

Yep it was a theme thing, but I also got the same Precondition failed error. Uncanny! I can’t get rid of it and WordPress the only place it exist.

Well guys, your help has been appreciated, but for now I’m going to put this to bed or I’ll be at it until Christmas.

However, I learn a lot along the way. Thank you for that.

Steve