cancel
Showing results for 
Search instead for 
Did you mean: 

MySQL Database import

SoulBriski
Grafter
Posts: 179
Registered: 15-06-2007

MySQL Database import

Hi
I'm having trouble importing a MySQL database so i can do some testing.
The database is a copy of one from my live site but there is a permissions issue.
How can i set the permissions on my exported database from the live site to allow me to import into the new one on the trial server?
4 REPLIES
Kev_Mawson
Grafter
Posts: 196
Registered: 05-04-2007

Re: MySQL Database import

Hi
So I can look in to this for you, can you please provide me the domain, which is using the database at present so that I can have a look for you.
SoulBriski
Grafter
Posts: 179
Registered: 15-06-2007

Re: MySQL Database import

The database is on my current PN account at www.jnmbc.co.uk
This is the error message
Error
SQL query:
--
-- Database: `thesmartfamily_pn`
--
CREATE DATABASE `thesmartfamily_pn` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

MySQL said: 
#1044 - Access denied for user 'soulbriski'@'%' to database 'thesmartfamily_pn'
Kev_Mawson
Grafter
Posts: 196
Registered: 05-04-2007

Re: MySQL Database import

Hi
I have now moved your database across for you, the problem was caused by you needing to remove everything before the create table section when you export it from your Plusnet space.
I have now imported the data in to the empty database that you had setup on PAYH.
Hope that helps.
SoulBriski
Grafter
Posts: 179
Registered: 15-06-2007

Re: MySQL Database import

Once again I thank you.
I looked at the export options to see if i could remove anything related to the specific database but could find anything.
I realise this is not the place to dwell on that subject so i will do that in the general forum at some point.