LinuxQuestions.org
Review your favorite Linux distribution.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Non-*NIX Forums > General
User Name
Password
General This forum is for non-technical general discussion which can include both Linux and non-Linux topics. Have fun!

Notices


Reply
  Search this Thread
Old 07-04-2014, 10:28 AM   #1
harry_ord
Member
 
Registered: Nov 2012
Posts: 61

Rep: Reputation: Disabled
Problem moving my database to a new server


Hello

I had a Wordpress website wit the domain "bioskincare.com" in a hosting (let's call it A), and now i have a new hosting (B) and i want to move the site in the old hosting(A) to the new one (B) and with a new domain: "linkschile.com".

I did the following:

-I copied all the files from the folder "public_html" of the old hosting (A) to the new hosting(B).

-I went to the phpmyadmin of hosting A (the old one) and exported the database compressed in bzip.

-I created a new database in hosting B (the new one)and a user with full priviledges on it.

-Now i go to the phpmyadmin in hosting B (the new one) and go to "import", then i choose the bzip file that contains the database downloaded from hosting A (the database from the old site).

-When i do the last, i get this message:

consulta SQL:


--
-- Base de datos: `bioskin_cart`
--
CREATE DATABASE `bioskin_cart` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
MySQL ha dicho: Documentación

#1044 - Access denied for user 'linkschi'@'localhost' to database 'bioskin_cart'


It's impossible for me to create a databe and username with the same names from hosting A inhosting B, because both hosting services use a prefix for the name that i can't change.

What can i do?
 
Old 07-05-2014, 04:53 PM   #2
pingu
Senior Member
 
Registered: Jul 2004
Location: Skuttunge SWEDEN
Distribution: Debian preferably
Posts: 1,350

Rep: Reputation: 127Reputation: 127
It looks like you didn't get the permissions right.
Permissions for a user are always defined together with user's location. Make sure you set permissions for 'linkschi'@'localhost'. Also check what permissions you granted.
One thing could be that you try to create a database that you already have.
So log in to mysql on B and check the permissions:
SHOW GRANTS FOR 'linkschi'@'localhost'
 
  


Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Moving large mySQL database fruitwerks Linux - Enterprise 3 08-01-2013 08:50 AM
[SOLVED] Moving only ONE MySQL database to a different folder, is it possible? lpallard Linux - Server 2 12-30-2012 12:01 PM
Moving an old database from HP UX server nmuleski Other *NIX 11 05-16-2011 08:04 AM
Problem with server after moving it.. SARO91201 Linux - Networking 1 12-02-2005 07:55 AM
Moving mySQL database subnet_rx Linux - Software 12 06-30-2004 04:41 PM

LinuxQuestions.org > Forums > Non-*NIX Forums > General

All times are GMT -5. The time now is 04:10 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration