OmArEmAd
Aug 14 2007, 01:23 PM
| | 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.... 
What shall i do??
I need Help Please |
Reply
hibbso
Aug 14 2007, 02:23 PM
i get that problem. But for starters mySQL is a foreign language to me. Sorry .
Reply
Tramposch
Aug 14 2007, 03:17 PM
did you set the right permissions for that database? I think that might be the problem, when you make the database, you need to asign a username thing to it, and then set its permissions :/ if not, idk sorry
Reply
street
Aug 14 2007, 03:40 PM
While saving your sql information from your old site did you save it in the gzip format. Cause if you save it .zip phpmy admin will not be able to import your data.
Reply
shadowx
Aug 14 2007, 03:56 PM
First things first, have you created the database using the database tool that is NOT inside PMA? In the cpanel there is a tool called "MYSQL DATABASES" in there are the tools for you to create the database itself, you cant create any databases within PMA on T17, you need to use the tool i mention. I dont think you need to create a new user to use PMA but bare in mind that to use a script, eg PHP with a username you will need to create this user using the tool i mentioned above. Once thats all been done try getting the raw SQL code from your export and just nav to the database you want to create tables in and paste the code into the SQL box under the SQL tab and that should work. If this is what youre already doing then try checking the permissions for your users in the tool i said above, if there are no users then create one and give it full permissions, you could try a ROOT user if it isnt there already, if it is then give it full permissions and try again.
Reply
75rLs3U4
Aug 14 2007, 07:43 PM
It's weird to "don't have permissions" with the database. I always do this: Export the database in version 4.0 and zip, checking "drop database" (I don't like to make incrementals) Create a database in other hosting, take note of the name of it, the username and the password Choose the database created in mysql and then import the zipped database Hope this steps help you to have your database working in the new site...
Reply
fffanatics
Aug 14 2007, 11:41 PM
Make sure you are exporting the database as a proper version of sql and that you are importing the same version. Also, as others have said make sure the database already exists or else PHPMyAdmin will not let you create it on Trap17. Finally, make sure the database is correct and not corrupt since i have had bad exports before.
Reply
reconraiders
Aug 15 2007, 02:19 AM
QUOTE(shadowx @ Aug 14 2007, 11:56 AM)  First things first, have you created the database using the database tool that is NOT inside PMA?
In the cpanel there is a tool called "MYSQL DATABASES" in there are the tools for you to create the database itself, you cant create any databases within PMA on T17, you need to use the tool i mention. I dont think you need to create a new user to use PMA but bare in mind that to use a script, eg PHP with a username you will need to create this user using the tool i mentioned above.
Once thats all been done try getting the raw SQL code from your export and just nav to the database you want to create tables in and paste the code into the SQL box under the SQL tab and that should work.
If this is what youre already doing then try checking the permissions for your users in the tool i said above, if there are no users then create one and give it full permissions, you could try a ROOT user if it isnt there already, if it is then give it full permissions and try again. Exactly right on! That's what I was going to say. I'm sure that is the problem.
Reply
OmArEmAd
Aug 15 2007, 12:54 PM
jlhaslip
Aug 15 2007, 01:04 PM
Did you modify the SQL file to use the correct mysql information? If you are installing the database here on the Trap17, the database requires a prefix. Add "youruser-name_" to the front of the database. Check the MySQL tab in your cpanel to see what I mean. Example, for my account, the database is prefixed with "jlhaslip_" so the mysql file named "forum" becomes "jlhaslip_forum". Hope this helps.
Reply
jlhaslip
Aug 19 2007, 03:40 PM
Add your SQL file as an attachment to a Post, please, if it isn't too large...
Reply
OmArEmAd
Aug 19 2007, 03:35 PM
the problem is still with me whenever i try to import my .sql file it gives me errors... sometimes it tells me you are unauthorized... And sometimes SQL syntax error So what i have to doooooooo????????????????????????????????????????????
Reply
OmArEmAd
Aug 16 2007, 02:33 PM
Thanks Thanks Thanks Thanks Thanks  Thank you very much and thanks for giving me your time... Thanks you
Reply
jlhaslip
Aug 16 2007, 12:44 PM
CODE DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci;
USE omaremad_bestsoftsforum
DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci;
USE omaremad_bestsoftsforum; Assuming your cpanel user name is "omaremad", of course...
Reply
OmArEmAd
Aug 16 2007, 10:40 AM
QUOTE(jlhaslip @ Aug 16 2007, 04:40 AM) Just edit it, but be sure to save a copy of the original file under another name as a backup. Thanks jlhaslip for helping me And i'll edit the file and see if it will work or no but a small question that CODE -- Database: `bestsoftsforum`
--
CREATE DATABASE `bestsoftsforum` DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci;
USE bestsoftsforum; so shall I edit CODE -- Database: `bestsoftsforum` and CODE --
CREATE DATABASE `bestsoftsforum` and CODE DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci;
USE bestsoftsforum; to omaremad_bestsoftsforum??? or only CODE CREATE DATABASE `bestsoftsforum` please answer me
Reply
Recent Queries:--
sqlite latin1_german2_ci - 604.96 hr back. (1)
Similar Topics
Keywords : database, transfer, sites, database
- Mysql Database Not Working
(3)
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" />....
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....
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...? ....
I Need Help Transferring Sql Database?
(3) 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 A....
Transfer To Free Hosting? [resolved]
(9) I am in the negative points as we speak here just to state that. I have had a couple times when I
have went negative because of certain reasons but I have been way to busy lately to do anything but
my personal life. I can't afford to come check here and post as often as I used to. So my
question then would be is there any way I can get my account changed to free hosting with the text
ad? I would really like to not have to make a whole new account and lose all of the stuff from my
hosting now and also my forum account. If it is needed that I post up enough to get pos....
Site Down After Server Transfer
(3) Hello, I am wandering why my site is down after server transfer. I cannot access control panel
also. Few days ago I was able to ping the site however now I cannot do that either. My domain name
is: zedsi.com however my main traffic is comming from my blog: blog.zedsi.com Any suggestions why
it is still down would be appreciated. On the other hand I have checked on
www.xisto.com/network-status and gamma is online. Thanks in advance. Best Regards, Hitmanblood....
Directory Restricted?
I can't edit one of my site's directories (7) My website is split into two directories: "site", which is my main site's content, and "forum",
which explains itself. The "site" directory is mostly filled with Joomla! files due to my
website using the Joomla! CMS. Previously, I was able to upload templates and extensions to
Joomla! without fail. However, since today whenever I've done either of these I just get
"failed" messages. Unable to source it to a problem with Joomla, I tried to access the directories
using FTP. I was able to access and rename all my directories using FTP, but whenever I t....
My Site's Ip Address
Finding out my numerical IP address (5) Hi, I was wondering how I can find the numerical IP address of my site. I have my site hosted at
Trap 17, but instead of a subdomain i use my own (parked) domain name. Can anyone tell me how I can
find the address of my web site in the shape of 81.200.30.55 (this is just a random example) instead
of in the shape of http://www.vlaanderen-flanders.org.uk ? Thanks for any advice. ....
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 ....
File Transfer From Angelfire To Trap17?
P.S. I use my Wii. (1) I'm wondering, how would I do this. Also, how would I install IPB or PHPBB3. I just have those
questions.....
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
....
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?....
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......
Credits Transfer!
on what circumstances would you do it? (7) As it is possible to transfer credits between hosted members there must be some reason to do so. On
what circumstances would Admins transfer credits to us? If I am like going on vacation tomorrow and
dont have enough credits to keep my site up till I'm back, would they/you give me credits to
help?....
Transfer Failed.
(3) I use Smart FTP, and I can't seem to transfer files. Everytime I try, it just fails.
Here's a log: QUOTE Remote file exist check: "index.html". TYPE I 200 TYPE is now 8-bit
binary SIZE index.html 213 10830 MDTM index.html 213 20040909060935 No rule matched.
Default Action="Ask". PORT 24,61,73,215,8,68 200 PORT command successful STOR index.html 553
Rename/move failure: Read-only file system MDTM 20060831042008 index.html 550 Can't check
for file existence TYPE A 200 TYPE is now ASCII PORT 24,61,73,215,8,70 200 PORT co....
Upload Script To Transfer Files From Laptop To Desktop
(3) Would it be allowed to have an upload script to transfer text files (homework) from laptop to
desktop? Because my printer is set up from my desktop, and most of my homework is done on my laptop.
So would this be allowed? Thanks.....
How Can I Transfer Credits To My Friend ?
(5) Yes , my friend really need some credits from me but how can I transfer some of them to him ? I
tried at the process page but it always said "You need more to transfer" , what should I do now ?
Please help me , thank you very much.....
Sites Disapeard, Mysql Errors? Also Server Folders Deleted
(18) Hello its 15:40 and I login see if everything runs oke, and I see numerus things deleted my mysql is
working again. Whats going on? My Webpage couple websites got deleted, and server folder files now
whats going on? /sad.gif" style="vertical-align:middle" emoid=":(" border="0" alt="sad.gif" /> my
forum also give errors but mysql db stil there /sad.gif" style="vertical-align:middle" emoid=":("
border="0" alt="sad.gif" />.......
Can I Transfer Credits From Trap 17 To Asta Host?
Is it possible? (2) I was wondering if i could somehow transfer some of my credits from my Trap 17 account to my Asta
host account because i have gained many credits here at Trap 17 and i am having a hard time gaining
that many credits there.I just want to transfer maybe a months worth of credits (30 credits) And
thats it. I have been very busy lately and it's hard to post on both forums and post enough to
gain a good amoun of credits. If it's not even possible that's ok. Thanks anyways. P.S.
Both forum accounts are BooZker.....
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?....
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: ....
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?....
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!....
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....
Ftp Double-click Caution
...with multiple sites - be careful with the double-clicking (5) I just want to put out a little caution for everybody. Be very careful when using most FTP transfer
programs. If you double-click on any file (either local, or remote) it usually transfers that file
across to the other side. Be especially careful if you have set up the default to overwrite. I
found this out when I was doing some admin with a PhpNuke site, and I wanted to view its config.php
file, but I transferred that file to my local directory (which was a local nuke). At the time, I
just thought it was strange that the file didn't view or launch.... but, it s....
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 ....
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....
Domain Name Transfer.
Just to make sure i do it right (6) ok, well i signed up for one of those .be domain names, and i was wondering...to transfer it all i
need to do is go to trap17.com/process/changedomain.htm and enter the domain i signed up for? and
it will become that? im asking because it will cost me 15 credits if it works or doesn't work..
so i just want to make sure i do it right..lmao even though its kind of obvious....
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....
Looking for database, transfer, sites, database
|
*RANDOM STUFF*
*SIMILAR VIDEOS*
Searching Video's for database, transfer, sites, database
*MORE FROM TRAP17.COM*
|
advertisement
|
|
.........
