MyBB Community Forums

Full Version: backuping databases error
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Quote:Error

SQL query:

-- MyBB Database Backup
-- Generated: 06th September 2009 at 04:44
-- -------------------------------------
CREATE TABLE mybb_adminlog (
uid int( 10 ) unsigned NOT NULL default '0',
ipaddress varchar( 50 ) NOT NULL default '',
dateline bigint( 30 ) NOT NULL default '0',
module varchar( 50 ) NOT NULL default '',
action varchar( 50 ) NOT NULL default '',
data text NOT NULL ,
KEY module ( module , action )
) ENGINE = MYISAM DEFAULT CHARSET = utf8;

MySQL said: Documentation
#1050 - Table 'mybb_adminlog' already exists

ive encounter this kind of matter while doing database backup?..

anyone of you guys can guide me?
The error says what it says, the 'mybb_adminlog' already exists. I take it you're importing this backup, yeah?? Well it looks like there's already tables there so it can't import, drop the tables that are currently there, and then import the backup.
can u guide me boss. if how this work?.
coz i am noob Sad
if u importing the table then remove the old mybb_adminlog table by tick mark it.and then click the button x in ur right side.

then import that table again
Quote:Error
There is a chance that you may have found a bug in the SQL parser. Please examine your query closely, and check that the quotes are correct and not mis-matched. Other possible failure causes may be that you are uploading a file with binary outside of a quoted text area. You can also try your query on the MySQL command line interface. The MySQL server error output below, if there is any, may also help you in diagnosing the problem. If you still have problems or if the parser fails where the command line interface succeeds, please reduce your SQL query input to the single query that causes problems, and submit a bug report with the data chunk in the CUT section below:
----BEGIN CUT----
eNpzDQryD7JScDZUcDZS8HH1s1IwUDBUMDIwt+QKDgFKyHNxBYcBRVU8U6wUigtzChKLilOL9HIy
k/QKMgoUDA1NLYyByg0sdA0sdQ0NFQzNrQyMrUwsoxRyUnMtFVS4fCuDA32sFEz1DPQsTHQNuUKD
gxT8g3UUHN1d/UJ0FMJcgZaEZ+YpuLs6e/srGOpZcgX4OlopGOsZ6hlyBXgEgFTo+AeDTDDSM9M1
1M5JzcurNFbwycwrreDycfRzt1JIzdMtLUnTteACWyXfzcEABsy9/QfzmhwE2t6r5ZRYH60XFvK8
cGzJ1o8Mu7Yu8xA+6Ox/96Ds22UbBCJm/fo2NeS2c3WB3+ST5vftH/+OkF/Mwb1pSvDpjozv9672
vU8+2Sa9ac0yif6o7inZp1PPcR1zLGDfxKGWmFtgffnjCve/2acKn0kLpjFFShxl2gSy7dlP7ZVB
sxdZeezgU7AeddGoi0ZdNOqiUReNumjURaMuGnXRqItGXUR9FwEAh4m74Q==
----END CUT----
----BEGIN RAW----

ERROR: C1 C2 LEN: 0 1 2079
STR: 

SVN: $Id: sqlparser.lib.php 11583 2008-09-11 17:03:49Z lem9 $
MySQL: 5.0.84-1
USR OS, AGENT, VER: Win GECKO 1.9
PMA: 3.1.1
PHP VER,OS: 5.2.6-1+lenny3 Linux
LANG: en-utf-8
SQL: ����������n�@��<�I�Ƥ������H�CO���X���T�C{pN��7�?��X� ��Sˈh��Վ�cɆ����Z��k�e�
�Ap�&��G�k�q�fY��<��+�R��:H� ;����������n�@��<�I�Ƥ������H�CO���X���T�C{pN��7�?��X� ��Sˈh��Վ�cɆ����Z��k�e�
�Ap�&��G�k�q�fY��<��+�R��:H� ;����������n�@��<�I�Ƥ������H�CO���X���T�C{pN��7�?��X� ��Sˈh��Վ�cɆ����Z��k�e�
�Ap�&��G�k�q�fY��<��+�R��:H� ;����������n�@��<�I�Ƥ������H�CO���X���T�C{pN��7�?��X� ��Sˈh��Վ�cɆ����Z��k�e�
�Ap�&��G�k�q�fY��<��+�R��:H� ;����������n�@��<�I�Ƥ������H�CO���X���T�C{pN��7�?��X� ��Sˈh��Վ�cɆ����Z��k�e�
�Ap�&��G�k�q�fY��<��+�R��:H� ;����������n�@��<�I�Ƥ������H�CO���X���T�C{pN��7�?��X� ��Sˈh��Վ�cɆ����Z��k�e�
�Ap�&��G�k�q�fY��<��+�R��:H� ;����������n�@��<�I�Ƥ������H�CO���X���T�C{pN��7�?��X� ��Sˈh��Վ�cɆ����Z��k�e�
�Ap�&��G�k�q�fY��<��+�R��:H� ;����������n�@��<�I�Ƥ������H�CO���X���T�C{pN��7�?��X� ��Sˈh��Վ�cɆ����Z��k�e�
�Ap�&��G�k�q�fY��<��+�R��:H� ;����������n�@��<�I�Ƥ������H�CO���X���T�C{pN��7�?��X� ��Sˈh��Վ�cɆ����Z��k�e�
�Ap�&��G�k�q�fY��<��+�R��:H� ;����������n�@��<�I�Ƥ������H�CO���X���T�C{pN��7�?��X� ��Sˈh��Վ�cɆ����Z��k�e�
�Ap�&��G�k�q�fY��<��+�R��:H� ;����������n�@��<�I�Ƥ������H�CO���X���T�C{pN��7�?��X� ��Sˈh��Վ�cɆ����Z��k�e�
�Ap�&��G�k�q�fY��<��+�R��:H� ;����������n�@��<�I�Ƥ������H�CO���X���T�C{pN��7�?��X� ��Sˈh��Վ�cɆ����Z��k�e�
�Ap�&��G�k�q�fY��<��+�R��:H� ;����������n�@��<�I�Ƥ������H�CO���X���T�C{pN��7�?��X� ��Sˈh��Վ�cɆ����Z��k�e�
�Ap�&��G�k�q�fY��<��+�R��:H� ;����������n�@��<�I�Ƥ������H�CO���X���T�C{pN��7�?��X� ��Sˈh��Վ�cɆ����Z��k�e�
�Ap�&��G�k�q�fY��<��+�R��:H� ;����������n�@��<�I�Ƥ������H�CO���X���T�C{pN��7�?��X� ��Sˈh��Վ�cɆ����Z��k�e�
�Ap�&��G�k�q�fY��<��+�R��:H� ;����������n�@��<�I�Ƥ������H�CO���X���T�C{pN��7�?��X� ��Sˈh��Վ�cɆ����Z��k�e�
�Ap�&��G�k�q�fY��<��+�R��:H� ;����������n�@��<�I�Ƥ������H�CO���X���T�C{pN��7�?��X� ��Sˈh��Վ�cɆ����Z��k�e�
�Ap�&��G�k�q�fY��<��+�R��:H� ;����������n�@��<�I�Ƥ������H�CO���X���T�C{pN��7�?��X� ��Sˈh��Վ�cɆ����Z��k�e�
�Ap�&��G�k�q�fY��<��+�R��:H� ;����������n�@��<�I�Ƥ������H�CO���X���T�C{pN��7�?��X� ��Sˈh��Վ�cɆ����Z��k�e�
�Ap�&��G�k�q�fY��<��+�R��:H� ;����������n�@��<�I�Ƥ������H�CO���X���T�C{pN��7�?��X� ��Sˈh��Վ�cɆ����Z��k�e�
�Ap�&��G�k�q�fY��<��+�R��:H� ;����������n�@��<�I�Ƥ������H�CO���X���T�C{pN��7�?��X� ��Sˈh��Վ�cɆ����Z��k�e�
�Ap�&��G�k�q�fY��<��+�R��:H� ;

----END RAW----

SQL query:

����������n�@��<�I�Ƥ������H�CO���X���T�C{pN��7�?��X� ��Sˈh��Վ�cɆ����Z��k�e� �Ap�&��G�k�q�fY��<��+�R��:H� ;

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 '‹' at line 1
Where did you get that?? :|
i get that error when i import my backup file..

Sad
that looks like it tried to import a gzipped dump without gunzipping it first...
same things happen Sad...
Try importing the files at a time, it may identify your problem.
If that is possible, of course.