need help moving database!

[hexzar]

hey, basically i got ipb forums on another host. Now i want to switch all the info to this host.

I really don't know how to move the database, i've uploaded the "forums" file to this. But when i try to upload the database it comes up with errors like -

[B]Error[/B]

     [B]SQL query:[/B]     
              -- phpMyAdmin SQL Dump
-- version 2.9.0.2
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Dec 12, 2006 at 12:27 PM
-- Server version: 4.1.21
-- PHP Version: 4.4.2
-- 
-- Database: `hexzar_blasphemy`
-- 
 CREATE  DATABASE  `hexzar_blasphemy`  DEFAULT  CHARACTER  SET latin1 COLLATE latin1_swedish_ci;

     
      [B]MySQL said: [/B][URL="http://dev.mysql.com/doc/mysql/en/error-messages-server.html"][IMG]http://blasphemy.my.host-us.net:2082/3rdparty/phpMyAdmin/themes/original/img/b_help.png[/IMG][/URL] 
  #1044 - Access denied for user 'blasphem'@'localhost' to database 'hexzar_blasphemy'

help...

 

[YamiKaitou]

All database begin with your cpanel username. You would have to change that query so it creates a database with the appropriate name, and example woould be 'CREATE DATABASE `blasphem_blasphemy` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

 

[hexzar]

then it comes up with the error, this database already exists?

 

[hexzar]

now it says this -

mySQL query error: SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'chatting','birthdays','calendar','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages','grouporder_cache','sbox_colors' )

SQL error: Table 'blasphem_blasphemygzkey.ibf_cache_store' doesn't exist
SQL error code:
Date: Tuesday 12th of December 2006 01:43:00 PM

And this is when i go to my url....

 

[Zenax]

Could you not simply download a back up of your database then upload it onto here, hence transfering all files and options?

Regards,
Zenax

 

[YamiKaitou]

If it is saying that a table does not exist, then the table does not exist.

Go into phpMyAdmin on your other host and select the database and then choose export. Select all of the tables and tell it to save it. Then on the phpMyAdmin here, select your database and then choose import. Navigate to your file you just made and select it. Should work fine