I Need Help Transferring Sql Database?

free web hosting
Open Discussion > General > Hosted Members Area

I Need Help Transferring Sql Database?

jjaenagle
ok so i am trying to transfer mediawiki's but i am having trouble with exporting importing the database.

I am using phpmyadmin on both sides of the hosts. When i do the import i get this.


QUOTE
SQL query:

--
-- Database: `apolopedia`
--
CREATE DATABASE `apolopedia` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

MySQL said: Documentation
#1044 - Access denied for user 'jaenagle'@'localhost' to database 'apolopedia'
I tried to give my user all rights, but it gave me this also.


QUOTE
SQL query:

GRANT ALL PRIVILEGES ON * . * TO 'jjaenagle'@'%' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;

MySQL said: Documentation
#1045 - Access denied for user 'jjaenagle'@'%' (using password: YES)




Do you guys have any advice?

 

 

 


Reply

sonesay
It appears you do not have the right privileges. If you have no control of setting it i.e your using MYSQL on a remote host you have little or no control over then you cant do much about it.

Reply

jjaenagle
can i contact the admins and see if they can grant me privileges? what do i need to do?

im very new to this.

i have asked the same question in their forum so hopefully, someone can help me out.


Reply

jlhaslip
The database user name is always prefixed with your cpanel name and an underscore.

example: my Cpanel name is jimbo and it causes the db_username to have a prefix of jimbo_ (with the underscore).


In the configuration file for the script being installed, or in an SQL command like above, I would use the db user-name of jimbo_username to access the DB where username is the user for that db..

You appear to be missing either the prefix or the username in the above example you quote.

Reply



Got an Opinion! Express your Views! (no registration):-
Add your Reply/ Opinion/ Views/ Comments/ Suggestion/ Questions/ Queries etc.
Posts with decent grammar & English will be accepted and please refrain from profanities.
For asking a Question, We recommend you to sign-up (for free) so that you can track the topic easily.

Nature of your Post*: Opinion/ Reply/ Comments
Question/Query
Feedback to us.
       
Name   Email
Title/Question*

(Maximum characters: 10,000)
You have characters left.

Recent Queries:-
  1. transferring a mysql database 1044 - 107.96 hr back. (1)
  2. как переводится guangdi - 283.80 hr back. (1)
Similar Topics

Keywords : transferring sql database

  1. Mysql Database Not Working - (3)
  2. Ips Installer Database Details [resolved] - It wont accept localhost... (6)
    CODE Access denied for user 'skyed211_central'@'localhost' to database
    'skyed211_centralgaming' I get this error message when trying to install my IPB. It will
    not accept localhost, nor mysql. Can I get any help please? I've tried many times to get past
    this part, but it's not happening /sad.gif" style="vertical-align:middle" emoid=":(" border="0"
    alt="sad.gif" />...
  3. Mysql Database Setup : Setting Up Mysql Database - Guide to use MySQL database in your site (6)
    A SMALL INTRODUCTION TO DATABASE ============================= I have seen that many members have
    problems with Database. Here is a small INFO which should give you the IDEA. mySQL is a DATABASE
    server. You can access it using the link in Cpanel. Cpanel can be accessed by
    "www.YOUR-SITE.com/Cpanel" There you have 4 Main Options :- 1> CREATE A DATABASE 2> CREATE A USER
    3> ADD USER TO DATABASE 4> PHPMYADMIN CREATE : IT ALLOWS YOU TO CREATE A DATABASE CREATE USER
    : IT ALLOWS YOU TO CREATE A USER. USING THIS, YOU CAN ACCESS THE DATABASE. A DATABASE CANNOT BE...
  4. Phpmyadmin - Create new database: No Privileges (7)
    i can not make a sql for diff srcipt, but the sricpt i have is php, DJ-cpanel.. all tho i can not
    install it the error is like this Creating Database Tables No database selected there a mysql
    database is made, but i can not use it for othere stuff... plz note that this is Free script and not
    for paid.. is there a way that the myqsul can not use sql other scripts? or it maybe not working...
    but i am not sure if the script not working or it can be the server may be down on mysql...? ...
  5. Is The Database System Gone Again? [resolved] - Errors on PHPMyAdmin again (12)
    I wonder if there is a problem with the PHPMyAdmin system again? When trying to get into it, I once
    again get the following: QUOTE Warning: session_write_close() : SQLite: session write query
    failed: database is full in /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php on line 42
    Warning: session_write_close() : Failed to write session data (sqlite). Please verify that the
    current setting of session.save_path is correct
    (/var/cpanel/userhomes/cpanelphpmyadmin/sessions/phpsess.sdb) in
    /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php on line 42 Warning: Ca...
  6. Changes In Phpmyadmin - Access to my database from program not working anymore. (0)
    I was wondering if something has changed in the MySQL or PHPMyAdmin section of Trap 17. (Hope I am
    explaining this correctly). I run a newsletter system on my website and the details of the people
    who subscribed are in a MySQL database. To get those data from the database and to send the
    newsletter to all subscribers I use a program called "Qios Pelican". Up to now it always worked
    perfectly, but now it cannot seem to retrieve data anymore, yet I have not changed anything to my
    setup. I use the MySQL OLEDB Provider driver to connect, and in case it helps, here are the ...
  7. Transferring Files From One Host To Another - Take my site to trap17 (8)
    As I said, I had to move my web site away from Trap17 temporarily because I had ran out of disk
    space. Now, when my upgrade is finalised, I would like to ask for a little assistance. The provider
    I will be moving my site from, back to Trap17 also uses Cpanel, and the admin let me know to do a
    backup and that backup could be simply transferred via FTP to my new provider. The backup includes
    all my files and MySQL data, in other words, the whole web site. It is in a .tar.gz format. How do I
    get all this across? Do I 'unzip' the file and then transfer them bit by bi...
  8. How To Crate Mysql Database? - urgent help (7)
    Hi everyone!
    I'm trying to make in my site a page system that allows me to create users
    account (with a foto for every user)...
    I'm doing that in PHP, I learned all I have to
    know about PHP and MY SQL. I know how to make new array and querries in the data base, only 1 think
    is messing: ...
  9. Need Help With My Database - I cannot transfer my old site's database (19)
    I Couldn't import my database info via Import from php my admin and i got the .sql file from the
    php my admin of my old hosting and every time i try to import it give me an error that i don't
    have the permissions to do.... /sad.gif" style="vertical-align:middle" emoid=":(" border="0"
    alt="sad.gif" /> What shall i do?? I need Help Please...
  10. Installing Phpbb - database problem (0)
    Hey guy's, ive done as you said and tried to install my phpbb without fantastico. I have got to
    the the install page then i get a mysql error QUOTE Warning: mysql_error(): supplied argument
    is not a valid MySQL-Link resource in /home/tdm/public_html/forum/phpBB2/db/mysql4.php on line 330
    Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in
    /home/tdm/public_html/forum/phpBB2/db/mysql4.php on line 331 phpBB : Critical Error Could not
    connect to the database Im not sure why this has happened as i have never really used mysql for
    ...
  11. Database Connection Problem - phpBB2 installation error (5)
    *edit* Ok well the original problem has been solved. I have installed phpBB2 on my new how here.
    Transfered all of the database files over. On my new forums all of the old posts and everything
    shows up right. The problem is when I click the "Go to administration panel" at the bottom it links
    me to log into my ACP on my old forums. It changes the url and all. If I hover over the link it
    says that it will be directed to the right way, the way I want, but it doesn't. Does anyone
    know anyway to fix this?...
  12. Database Errors! - Started after HDD change.. (5)
    Hello, I am having database errors. They started after yesterdays HDD change. Its all fine when i
    refresh site, they not that often but still i get them. It says "could not connect to database". And
    i also received mail from gamma.xisto.com which says: QUOTE There has been a problem with the
    database! This is a notice email to let you know that SMF could not connect to the database,
    contact your host if this continues. so i am contacting my host.....
  13. Transferring One Forum Data To Another Forum - How To Do This ? Another forum help. (7)
    I want to creat another Forum and delete the old one with the same Domain. But is there any way to
    transfer all the topics in the old one to the new one with proper sorting , date created , ..... ?
    Do I have to creat another MySQL Data base , Uername , ..... ? Please help me. Thank you. Topic
    title modified. Please use complete sentences. ...
  14. Database Is Deleted - database is deleted today (6)
    Today ,I access to my website and It can't connect to database,so I came to cpanel and I saw
    that my database is deleted.I have a question here ,why do my database is deleted?...
  15. Trap17 Database Problems? - (10)
    is it just me or is trap17 having issues now adays? for the past two days the forums have basicly
    been down except for a small period of time last night and just starting like 5 minutes ago..... is
    it just me, or is everyone getting this?...
  16. Mysql Database Problem - appears to be deleted, but still has data (6)
    Hello. My Mysql databases appear to have been removed off of my account, yet according to my
    cpanel, space is still being used on databases. Hopefully I haven't lost any of my data,
    because I haven't taken a backup after recent updates, but If I have, I'll have to make do
    with previous backup. Any idea what's wrong? Here's a quote from my cpanel QUOTE
    Mysql databases 0 / 99 PostgreSQL Databases 0 / 99 Disk usage 13.16 / 150.00 MB SQL
    Disk usage 2.99 MB As you can see, my database data still appears to be on the system, b...
  17. Recommand A Good Database Module Or Component On Mambo - (0)
    Hi guys, I want to have a database function in my mambo website, and I was wondering if it its easy
    to upload a Microsoft Access database into Mambo or if there is a Mambo Module or Component that
    adds a database feature to the website? My database would be quite large several thousand entries
    and I would like to enable to end-user to cross search on several variables on the database such as
    by 'location' and 'Services offered' so any suggestions on which is the most
    suitable database prog around for my needs? Thanks in advance!...
  18. Is It Possible To Move Only Part Of A Mysql Database - more like copying it and putting it elsewhere (4)
    Ok, well on my forums, i have two different forums, one for Role Playing (Harry Potter Role Playing
    not $3x) and the other is for general harry potter discussions, and i added over 100 smilies to
    my rpg forums, and i am guessing that the area that they store the shortcuts for it is in a mysql
    database because i cannot find it anywhere else, and so i am curious if there is any way that i can
    copy the part of the mysql database and move move to copie to the other database, so i dont have to
    enter over 100 shortcuts AGAIN....because i basicly added all of the yahoo me...
  19. Phpbb Forum Installation Problem - Update Database Error (4)
    Guys i was trying to install a phpbb modded forum, i followed this tutorial i had, and was about to
    install it fully when i got this error message An error occurred trying to update the database
    Table 'phpbb_admin_nav_module' already exists If anyone could tell me how to fix this it
    would be greatly appreciated. EDIT: I talked to a friend about the subject and he said i had to
    enter something after phpbb_ in the prefix for data tables or something, so then it came up with a
    file i had to download and ftp to the forum. So once i did that, i tried the forum ...
  20. X7chat2_0_0 Sql Database Privledge Error - (2)
    Im trying to set-up x7chat2_0_0 and i have entered all of the information the correct way, but i try
    to run the install program and it says that i do not have permission to access the database...but
    for the name i have it set for ALL RPIVLEDGES.. any suggestions?...
  21. Mysql Database Problem - (1)
    I was working on my site and the scripts said couldn't connect 2 database so when i went to
    check they were gone and i can't make anymore...
  22. Help With Mysql - Database Parameters (2)
    Hi, I need some help setting up a mySQL. I have install an auto members area script. Now it is
    asking me for the following information: QUOTE Database Host: MySQL host address - localhost
    will work in most cases Database Name: The database must already exist before installation
    Database Username: Username to access MySQL Database Password: Password to access MySQL (this will
    also used as the initial admin login password). I have never set anything like this up before.
    Can someone please help me set this up properly. Thank you....
  23. Database Error - down down... (11)
    QUOTE Warning: mysql_connect(): Can't connect to local MySQL server through socket
    '/var/tmp/mysql.sock' (2) in /home/guangdi/public_html/ons-com-ru/sources/Drivers/mySQL.php
    on line 67 Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in
    /home/guangdi/public_html/ons-com-ru/sources/Drivers/mySQL.php on line 70 ERROR: Cannot find
    database guangdi_i Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in
    /home/guangdi/public_html/ons-com-ru/sources/Drivers/mySQL.php on line 103 There appears to be...
  24. Transferring Domain To Computinghost.com ? - (3)
    I'm currently moving my site to computinghost.com .... so, I've set up an account ....
    now what? .... as I already have my own domain name, it asks me to "update my nameserver" .... how
    do I do that? also, does anyone know how I get access to computinghost cpanel? .... oh and,
    please keep it simple people .... Cheers .... ~M~ ...
  25. Database From Astahost To Trap17 - possible? (4)
    Hi all, I just got webspace on trap17. Before I had webspace on astahost, but couldn't get
    enough credits there. I had a forum there. Is it possible to put all what was there to here. I
    tried, but then my forum wants to redirect me to astahost and that's not what I want. Thanks in
    advance, Moody...
  26. Mysql Database Problem ! - (19)
    Ok my site was running like with no problems from the mySQL database for six months even more now it
    was made on PHP - Nuke i didnt touch anything when suddenly yesterday it said that there is a
    problem with the Database and we will be back shortly blah blah blah... anyway the site wasnt back
    about an hour ...i deleted the whole PHP-Nuke installation deleted the mySQL scripts etc etc and
    tried to start everything from scratch... Ne way what i wanted didnt happen... when i installed the
    new php-nuke the same error occured... it said that there are problems with the mySQL...
  27. What's Going On With The Mysql - database error and gd+ problems (6)
    this error is coming up Database error in vBulletin : Link-ID == false, connect failed mysql
    error: mysql error number: 0 I saw the problem the cpu and memory was at overload. Why is that?
    Also our images ain't coming up for gd+ and we had to disable image verification so new members
    can join...
  28. Save Database To Harddrive - Save database to harddrive (5)
    Is it possible save database from this server to my harddrive /unsure.gif' border='0'
    style='vertical-align:middle' alt='unsure.gif' /> or not I couldn't find right opration in
    myPhpadmin. I found "export" button in this tool but there are so many options and I am a little
    afraid to use it becouse I don't want to loos my data (actualy I wan save it /wink.gif'
    border='0' style='vertical-align:middle' alt='wink.gif' /> ). Or maybe it can be done throuth ftp
    browser? There are a lot of defoult folders (I even don't know for what are thay. I know just
    bub...
  29. Mysql Database Backup/restore Error - error with restoring backed up .sql file (3)
    hi there, im just wondering if anyone can tell me what is wrong when im trying to restore my sql
    databsse (sorry if this is in the wrong section but i guess this is the only section that i think
    this will fit in) QUOTE SQL-query: CREATE TABLE IF NOT EXISTS `e107_banlist` ( `banlist_ip`
    varchar( 100 ) NOT NULL default '', `banlist_admin` smallint( 5 ) unsigned NOT NULL default
    '0', `banlist_reason` tinytext NOT NULL , PRIMARY KEY ( `banlist_ip` ) ) ENGINE = MYISAM
    DEFAULT CHARSET = latin1 QUOTE MySQL said: Documentation #1064 - You have a...
  30. Cpanel And Mysql Database - My cpanel is busted and sql database (7)
    For some reason i login into my cpanel then it goes all blank... then next thing my mysql database
    shuts down... now i cant fix anything since i dont got cpanel... i cant access anything on my site
    someone please help me....



Looking for transferring, sql, database,

*RANDOM STUFF*





*SIMILAR VIDEOS*
Searching Video's for transferring, sql, database,

*MORE FROM TRAP17.COM*
Mysql
Database Not
Working
Ips
Installer
Database
Details
[resolved]
It wont
accept
localhost...
Mysql
Database
Setup :
Setting Up
Mysql
Database
Guide to use
MySQL
database in
your site
Phpmyadmin
Create new
database: No
Privileges
Is The
Database
System Gone
Again?
[resolved]
Errors on
PHPMyAdmin
again
Changes In
Phpmyadmin
Access to my
database
from program
not working
anymore.
Transferring
Files From
One Host To
Another Take
my site to
trap17
How To Crate
Mysql
Database?
urgent help
Need Help
With My
Database I
cannot
transfer my
old
site's
database
Installing
Phpbb
database
problem
Database
Connection
Problem
phpBB2
installation
error
Database
Errors!
Started
after HDD
change..
Transferring
One Forum
Data To
Another
Forum How To
Do This ?
Another
forum help.
Database Is
Deleted
database is
deleted
today
Trap17
Database
Problems?
Mysql
Database
Problem
appears to
be deleted,
but still
has data
Recommand A
Good
Database
Module Or
Component On
Mambo
Is It
Possible To
Move Only
Part Of A
Mysql
Database
more like
copying it
and putting
it elsewhere
Phpbb Forum
Installation
Problem
Update
Database
Error
X7chat2_0_0
Sql Database
Privledge
Error
Mysql
Database
Problem
Help With
Mysql
Database
Parameters
Database
Error down
down...
Transferring
Domain To
Computinghos
t.com ?
Database
From
Astahost To
Trap17
possible?
Mysql
Database
Problem
!
What's
Going On
With The
Mysql
database
error and
gd+ problems
Save
Database To
Harddrive
Save
database to
harddrive
Mysql
Database
Backup/resto
re Error
error with
restoring
backed up
.sql file
Cpanel And
Mysql
Database My
cpanel is
busted and
sql database
advertisement



I Need Help Transferring Sql Database?



 

 

 

 

ADD REPLY / Got an Opinion! a humble request :-) RAPID SEARCH! Free Hosting [X]
Express your Opinions, Thoughts or Contribute your information that might help someone here.
Ask your Doubts & Queries to get answers.. "Together, We enlight each other!"
Register FREE for AD-FREE forum, Create your own topics, Ask Questions, track topics, setup subscriptions & notifications and Get a Free Website w/ Email and FTP.
500MB Space *No Ads*, CPanel, FTP, PHP, MySQL, EMails - 100% FREE