Mysql Database Backup/restore Error - error with restoring backed up .sql file

free web hosting
Open Discussion > General > Hosted Members Area

Mysql Database Backup/restore Error - error with restoring backed up .sql file

jay2aust
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
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 smile.gif

Reply

jay2aust
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 smile.gif
*



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
hmm..BUMP...do need someone to verify the problem if its possible..thanks

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. mysql database backup using toad - 79.42 hr back. (1)
  2. 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

  1. Page Load Error When Trying To Get Into Control Panel - I just changed domain (2)
  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....
  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" />...
  4. 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...
  5. 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...? ...
  6. 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...
  7. 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...
  8. 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...
  9. 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....
  10. 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...
  11. 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...
  12. 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...
  13. 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?...
  14. 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?...
  15. 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...
  16. 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....
  17. 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??...
  18. 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....
  19. 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?...
  20. 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?...
  21. 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....
  22. 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...
  23. 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....
  24. 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?...
  25. 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?...
  26. 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....
  27. 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...
  28. 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....
  29. 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?...
  30. 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*
Page Load
Error When
Trying To
Get Into
Control
Panel I just
changed
domain
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
Error 28 (on
Phpmyadmin)
What does
this error
message
mean?
Hosting
Problem
[resolved]
403
Forbidden
Error occurs
whenever I
try to
access my
site
It Went Well
For A While
MySQL
problem back
in all its
glory.
Wordpress
Error -
Bytes
Exausted
[resolved]
NextGEN
Gallery
403
Forbidden
Error When
Accessing My
Site
Phpbb3 -
Error 28
Is The
Database
System Gone
Again?
[resolved]
Errors on
PHPMyAdmin
again
My File
Manager Is
Working
Backup Not
Working
[resolved]
How Do I
Find My
Mysql
Password?
[resolved]
Cannot
access my
MySQL
Page Load
Error When
Accessing
Cpanel
Coppermine
Gallery
Error
Remote
Access Mysql
Is It
Possible To
Access The
Mysql
Remotely?
File Manager
Not Working
Error Code
In
Subscription
s Page
problems
subscribing
to topics
I Need Help
Transferring
Sql
Database?
Issues
Uploading A
File
[resolved]
Unable To
Replace .png
File In
Directory
Can't
even delete
it using
Cpanel
How Do I
Make A
(video) File
Smaller?
Phpmyadmin
Error
[resolved]
Installing
Apache,
Mysql,
Phpmyadmin
Locally
Solving the
"php_mb
string.dll
missing"
;
Phpmyadmin
Error Not
able to
enter
PhpMyAdmin
Wordpress
Backup For A
Server Move
backing up a
Wordpress
site
Cannot
Delete
Folder After
Lost Ftp
Connection
permission
not given to
delete file
advertisement



Mysql Database Backup/restore Error - error with restoring backed up .sql file



 

 

 

 

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