Help with database

[manan35]

Please help me import database named database.sql which is in folder /home/ntarokz/public_html to my current database.Please help

[manan35]

help please

[MaestroFX1]

Use :
cpanel >> MySQL Database Wizard to create mysql database and user
cpanel >> phpmyadmin to import mysql database.

[manan35]

I cant use it, it gives me some error when I import it

[calistoy]

What error is it? Please give the exact error message.

[manan35]

Error
SQL query:

-- phpMyAdmin SQL Dump
-- version 2.6.4-pl2
-- http://www.phpmyadmin.net
--
-- Host: mysql14.freehostia.com
-- Generation Time: Apr 23, 2011 at 02:00 AM
-- Server version: 5.1.50
-- PHP Version: 5.2.6-1+lenny9
--
-- Database: `manmus9_123`
--
-- --------------------------------------------------------
--
-- Table structure for table `wp_commentmeta`
--
CREATE TABLE `wp_commentmeta` (

`meta_id` BIGINT( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
`comment_id` BIGINT( 20 ) UNSIGNED NOT NULL DEFAULT '0',
`meta_key` VARCHAR( 255 ) DEFAULT NULL ,
`meta_value` LONGTEXT,
PRIMARY KEY ( `meta_id` ) ,
KEY `comment_id` ( `comment_id` ) ,
KEY `meta_key` ( `meta_key` )
) ENGINE = MYISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT =1;

MySQL said:

#1050 - Table 'wp_commentmeta' already exists

[stpvoice]

What is the process you are going through? The host on x10 is localhost.

[MaestroFX1]

Hello again!

Use cpanel >> phpmyadmin.
Then, select your database and delete the table named "wp_commentmeta" or just check drop table option while importing.

Or if you want me to do it for you, feel free to PM me.
(Before 30th of this month only)

[gomarc]

Hi manan35,

From the SQL posted, it seems you are moving a WordPress from some previous hosting to x10hosting.

You may have installed a brand new WP here at x10 and you are now facing some trouble importing your database.

If this is your case, and as MaestroFX1 points out, you may have to DROP the tables of your new WordPress (table names starting with wp_ ) so they can be replaced by your backup. See this tutorial: Restore your database

If you haven't done it yet, check the WP official documentation: Moving WordPress to a New Server It's full for good tips and instructions.

[manan35]

I have imported database but my blog www.imfb.in not is running .I also cannot login into dashboard it gives me error.
Not Found

The requested URL /wordpress/wp-login.php was not found on this server.
Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

---------- Post added at 08:59 AM ---------- Previous post was at 12:20 AM ----------

someone help plz