jay2aust
Jul 17 2005, 11:12 AM
| | 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 an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1' at line 6
thanks
kenneth |
Reply
xJedix
Jul 17 2005, 05:51 PM
Im kind of guessing from the error since I don't know that much about sql.... but if your error message is correct, the "DEFAULT CHARSET=latin1" part is incorrect. Reasons for being incorrect. One possible reason is that the server doesn't have "latin1" charset. Another could be that the line of code is incorrect. My suggestion would be to try taking out the "CHARSET = latin1" part and see if it works. Otherwise you could just manually create the table through mysqladmin. Hope it helps
Reply
jay2aust
Jul 18 2005, 03:59 AM
QUOTE(xJedix @ Jul 18 2005, 01:51 AM) Im kind of guessing from the error since I don't know that much about sql.... but if your error message is correct, the "DEFAULT CHARSET=latin1" part is incorrect. Reasons for being incorrect. One possible reason is that the server doesn't have "latin1" charset. Another could be that the line of code is incorrect. My suggestion would be to try taking out the "CHARSET = latin1" part and see if it works. Otherwise you could just manually create the table through mysqladmin. Hope it helps  thanks for your reply.. i did take it out before but unfortunately it came up with a extreamly error after that so i thought i would post it here and maybe i should find out whats the defult char for trap17 server.. but anyway..thanks anyway... appreciate it
Reply
jay2aust
Jul 19 2005, 07:32 AM
hmm..BUMP...do need someone to verify the problem if its possible..thanks
Reply
Recent Queries:--
mysql database backup using toad - 79.42 hr back. (1)
-
how to create mysql database backup file using toad - 247.63 hr back. (1)
Similar Topics
Keywords : mysql database backup restore error error restoring backed sql file- Page Load Error When Trying To Get Into Control Panel
- I just changed domain (2)
- Mysql Database Not Working
- (3)
well i'm getting an error message(a databass connection warning) for all of the parts of my site
that connects to a mysql database i check my database users pertmissions and i try to do the repair
database thing and it's still not woeking. am i the only person having this or is it an overall
trap17 issue and how do i fix it....
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" />...
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...
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...? ...
Error 28 (on Phpmyadmin)
- What does this error message mean? (10)
I have a shopping cart system on my website. It always worked before, but all of a sudden, when I
try to access it i get "Got error 28 from storage engine". Has that got something to do with the
recent problems again, or can someone tell me what this error message means? Thanks. After posting
this I noticed I cannot get into my PHPAdmin anymore. It gives loads of errors: 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() :
Fai...
Hosting Problem [resolved]
- 403 Forbidden Error occurs whenever I try to access my site (22)
First off, let me say that I have spent considerable effort and time going through the forums
seeking solutions for this problem. I have even gone as far as to seek help from the Xisto Live
support team (they suggested I wait 2 hours and then get back to them. Well I did that, and there
has been no change, and live support is now down). I've also tried changing permissions on both
files and folders via Cpanel, but to no avail. I still end up with the same error: QUOTE
Forbidden You don't have permission to access /index.php on this server. Additionally, a 4...
It Went Well For A While
- MySQL problem back in all its glory. (5)
Some time ago I had a stubborn problem when trying to access one of the interactive pages on my
website and getting the following error: QUOTE Warning: fopen() : open_basedir restriction in
effect. File(include/errors.xml) is not within the allowed path(s):
(/home/mrdee:/usr/lib/php:/usr/local/lib/php:/tmp) in
/home/mrdee/public_html/admin/include/commonfunctions.php on line 682 Warning:
fopen(include/errors.xml) : failed to open stream: Operation not permitted in
/home/mrdee/public_html/admin/include/commonfunctions.php on line 682 Cannot open XML data file:
incl...
Wordpress Error - Bytes Exausted [resolved]
- NextGEN Gallery (7)
Hey, I have just gotten my blog up and migrated it from my own webserver. I have fixed up most
problems but one issue remains. When I try to upload an image to NextGEN Gallery I get and error
when it tries to generate a thumbnail. QUOTE Fatal error: Allowed memory size of 33554432 bytes
exhausted (tried to allocate 1992 bytes) in
/home/samlock/public_html/wp-content/plugins/nextgen-gallery/lib/thumbnail.inc.php on line 183
It does it for EVERY image size, so it's not because of a big image. Help, please....
403 Forbidden Error When Accessing My Site
- (11)
umm this is a problem that i have been looking in other topics to try to fix but i can't seem to
find a answer to what i lookin for. I got my site workin again the other day ok and so i went on to
see it (so i can make more changes) and when i got there i got this QUOTE Forbidden You
don't have permission to access / on this server. Additionally, a 403 Forbidden error was
encountered while trying to use an ErrorDocument to handle the request. Apache/1.3.33 Server at
www.clansga.trap17.com Port 80 now i looked at everything and i can't seem to find t...
Phpbb3 - Error 28
- (5)
I get the following error when I try changing a users group of my Phpbb3 powered forums. QUOTE
SQL ERROR Got error 28 from storage engine SQL SELECT ug.*, g.* FROM groups g, user_group ug
WHERE ug.user_id = 83 AND g.group_id = ug.group_id ORDER BY g.group_type DESC, ug.user_pending ASC,
g.group_name BACKTRACE FILE: includes/db/mysql.php LINE: 158 CALL: dbal->sql_error() FILE:
includes/acp/acp_users.php LINE: 1881 CALL: dbal_mysql->sql_query() FILE:
includes/functions_module.php LINE: 471 CALL: acp_users->main() FILE: adm/index.php LINE: 74 CALL:
p_master->l...
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...
My File Manager Is Working
- (2)
I tried to change the html for my site in file manager but it just has the default page - the one
when you activate your site. /sad.gif' border='0' style='vertical-align:middle' alt='sad.gif' />
How do i change files?...
Backup Not Working [resolved]
- (5)
I am trying to backup my files on my account(in preparation for the next server disaster), and I am
unable to download it. In my CPanel I goto the back-up screen to generate a full backup. Once
that's done and its ready to be downloaded, It only downloads to 13% or 50mb before stopping.
With and without a download manager. It doesn't help that resume is not supported in download
managers. I have too many files on my account to backup with an FTP client, that would take hours
and hours. What can I do to get a backup of my account?...
How Do I Find My Mysql Password? [resolved]
- Cannot access my MySQL (5)
After all the recent problems, my account has been restored. I have setup my parked domain agin, and
that works fine. However, I can no longer access my MySQL databases (I can from PHPMyAdmin, but
that's all). I had to create a new user for my databases, and created the user with exactly the
same username and password I had before, but some of my web pages do not let me access the pages I
have associated with my databases. Where could i find out what my DB password is? (Although I am as
good as sure I am using the right one). I have tried my old password, the new c...
Page Load Error When Accessing Cpanel
- (0)
Not sure what the issue is. I cannot even load up any of the cpanel's to allow me to put in a
password. I have tried the link that is located in the Credit System 2.0 I have tried the links
with subdomain/cpanel I have tried the links with subdomain:2082 All 3 of these just give page
load errors. Please note : This isn't a "my password doesn't work" thread. This is a "I
can't even get cpanel to TRY to load" thread. Thanks in advance....
Coppermine Gallery Error
- (2)
Okay.. so i have my gallery set up at photos.chantellepaige.org and everytime i try to access it i
get this error "Coppermine critical error: Unable to connect to database ! MySQL said: Access
denied for user 'giselle_copp1'@'localhost' (using password: YES)" how do i change
the password etc?? or fix the problem??...
Remote Access Mysql
- (8)
Is it possible to directly access my local database from my website? For example, if somebody
submits info on my website, the info they submitted would be transferred to my local database
directly. Is that possible? And if so, how do I set that up? The reason I don't want to upload
my database to my subdomain is because it would be difficult to keep the website database and my
local database in sync . . . or is there a way to do that? Thanks for any replies....
Is It Possible To Access The Mysql Remotely?
- (10)
I like to experiment with a lot of things and I was thinking of making a sort of instant messenger
in Python, but I want to let people have actual accounts so I need to be able to access the mySQL
remotely. If that's not possible, are we allowed to run Python scripts on the server?...
File Manager Not Working
- (2)
When I goto upload files using the file manager(legacy mode), the files do not upload correctly.
Every time I try to upload a file, it takes the time to upload it, but the file always comes out
being 0kb so it does not upload the file. Why is this happening?...
Error Code In Subscriptions Page
- problems subscribing to topics (5)
I'm seeing some weird warning message show up at the top of my page when I go into "my
controls," then load my topic subscriptions page. At the top of the page, the following code appears
several times: IPB WARNING in_array() : Wrong datatype for second argument (Line: 2711 of
/sources/action_public/usercp.php) I'm guessing maybe that has something to do with the fact
I'm having problems subscribing to my topics and posts? Thanks in advance for your help....
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...
Issues Uploading A File [resolved]
- (3)
Hi there. I have been trying to upload a zip file only about 2mb to my account through CPanel.
First I tried uploading it to a new folder in public_ftp. Then i tried to put it in the main part
of public_ftp. I also tried the same thing in public_html. It shows the file being uploaded, and i
get 100 %, but alas, when i look in the folders nothing is there. Is there a restriction on .zip
files? I have had no problems as of yet uploading htm and html pages. Please let me know ASAP.
Thank you....
Unable To Replace .png File In Directory
- Can't even delete it using Cpanel (7)
I can't delete a little file using file manager in Cpanel. I'm trying to delete a .png
image, actually, I'm trying to replace it. The response comes back as a success, but when I
reload my site it's still there. Then I go back to the file manager and go up a level, then back
and WOOP! There it is! I'm beyond frustrated here. What is going on?...
How Do I Make A (video) File Smaller?
- (11)
Ok, I want to host a video that I have in my computer, but the problem is that the video is too
big, 790MB. My host can't handle a file that huge so I was wondering if there is any way I can
make the video file in my computer smaller? I don't want to mess up the video and make it
smaller, I was wondering if I can keep the current 790MB video that I already have but copy only
about 10MB of the video into a new file that I can use for hosting. Anyone know?...
Phpmyadmin Error [resolved]
- (7)
I get this error message each time I attempt to work phpMyAdmin. QUOTE Cannot start session
without errors, please check errors given in your PHP and/or webserver log file and configure your
PHP installation properly. Help would be very grateful....
Installing Apache, Mysql, Phpmyadmin Locally
- Solving the "php_mbstring.dll missing" (5)
Since Trap17's CP provide the individual site's owner with goodies like MySql and
PhpMyAdmin, chances are some will want to make use of them. Well, it's fine enough to get that
on one's host (Gee! Thanks a lot, Trap17...) Knowing how the usual geek react, it might be
expected that most people considering to make use of a database on their site will want to do most
of the tedious job of developing and testing on their own local system before sending the wrapped-up
result on their domain/subdomain. This involves four basic steps (sorry for the compuwi...
Phpmyadmin Error
- Not able to enter PhpMyAdmin (4)
Currently I try to access my PhpMyAdmin and I get the following error displayed among the screen:
My PhpMyAdmin worked prior the migration but suddenly stopped working after. I wanted to know if
anyone else is getting this error also or anyway can help me fix this o.o....
Wordpress Backup For A Server Move
- backing up a Wordpress site (2)
i have question: how can we backup wordpress from fantastico...is it possible to backup and move
it to new host if you want?...
Cannot Delete Folder After Lost Ftp Connection
- permission not given to delete file (7)
hello, well i had created a subdomain and was transferring files into the folder i was disconnect
from the server many times while uploading the files via ftp once when i reconnect, i saw a file
with an unusual name something starting with preftp... i tried deleting the file, but it said that
permission was not granted to do that i tired deleting the complete folder and also tried deleting
the subdomain from the cpanel but it was of no use can anyone help me with this? thx for your time
Modified topic title. ...
Looking for mysql, database, backup, restore, error, error, restoring, backed, sql, file
|
*RANDOM STUFF*
*SIMILAR VIDEOS*
Searching Video's for mysql, database, backup, restore, error, error, restoring, backed, sql, file
*MORE FROM TRAP17.COM*
|
advertisement
|
|