MyBB Community Forums

Full Version: How do I restore from a back up?
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hi,
I uploaded a plugin and it crashed my entire database and I have reinstalled now I have no idea how to upload a back up. I cant see an option anywhere to do that. I did have the SQL thing but, I am not sure. what they mean.
Just import the database backup to a new one in phpmyadmin, and change your inc/config.php to point to new database.
Where is phpadmin?
In your host's control panel.
I am looking in my host control panel and there doesnt seem to be a phpmyadmin.
What control panel are you using?
its ok i have found it. i forgot my pin.
Its not working. I keep getting this
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----
eNpzDQryD7JScDZUcDZS8HH1s1IwUDBUsDQ24woOAYrLc3EFhwEFVTxTVLh8K4MDfawUTPUM9CwN
dXPy07lCg4MU/IN1FBzdXf1CdBTCXIFawjPzFPwDXIMcFSz1LAy4AnwdrRSM9AwNQciYK8AjAKRM
xz8YZJChnpmCT2ZeaQWXj6Ofu5VCap5uaUmargUX2CL5Rw07ORTAgPlQ76F+X//DTQ4CjxoWHF5/
eLf24XnSqocWeh5e7X5okQSf7qE1p9sObTM91Fh0eMPhJX6HdnPn6HBnlh/qPbz38PbDkzSqDk9w
Przc5FHLIrWcEuvDmw/tMT6071D/oS2HepMP9xzuCHI81Ovkc3jpo4Zd1qMWj1o8avGoxaMWE20x
APywFaM=
----END CUT----
----BEGIN RAW----
ERROR: C1 C2 LEN: 0 1 936
STR: 

SVN: $Id$
MySQL: 5.0.91-log
USR OS, AGENT, VER: Win OPERA 9.80
PMA: 2.11.11.3
PHP VER,OS: 5.1.6 Linux
LANG: en-utf-8
SQL: ‹ MOÂ@†ïû+Þ%¡IëG¢-¬ˆ¶5rðäN»
l,
iwý÷Ò(zÐCç4™<ó¼3¾´cÌÈRABLå›;‹ MOÂ@†ïû+Þ%¡IëG¢-¬ˆ¶5rðäN»
l,
iwý÷Ò(zÐCç4™<ó¼3¾´cÌÈRABLå›;‹ MOÂ@†ïû+Þ%¡IëG¢-¬ˆ¶5rðäN»
l,
iwý÷Ò(zÐCç4™<ó¼3¾´cÌÈRABLå›;‹ MOÂ@†ïû+Þ%¡IëG¢-¬ˆ¶5rðäN»
l,
iwý÷Ò(zÐCç4™<ó¼3¾´cÌÈRABLå›;‹ MOÂ@†ïû+Þ%¡IëG¢-¬ˆ¶5rðäN»
l,
iwý÷Ò(zÐCç4™<ó¼3¾´cÌÈRABLå›;‹ MOÂ@†ïû+Þ%¡IëG¢-¬ˆ¶5rðäN»
l,
iwý÷Ò(zÐCç4™<ó¼3¾´cÌÈRABLå›;‹ MOÂ@†ïû+Þ%¡IëG¢-¬ˆ¶5rðäN»
l,
iwý÷Ò(zÐCç4™<ó¼3¾´cÌÈRABLå›;‹ MOÂ@†ïû+Þ%¡IëG¢-¬ˆ¶5rðäN»
l,
iwý÷Ò(zÐCç4™<ó¼3¾´cÌÈRABLå›;‹ MOÂ@†ïû+Þ%¡IëG¢-¬ˆ¶5rðäN»
l,
iwý÷Ò(zÐCç4™<ó¼3¾´cÌÈRABLå›;‹ MOÂ@†ïû+Þ%¡IëG¢-¬ˆ¶5rðäN»
l,
iwý÷Ò(zÐCç4™<ó¼3¾´cÌÈRABLå›;‹ MOÂ@†ïû+Þ%¡IëG¢-¬ˆ¶5rðäN»
l,
iwý÷Ò(zÐCç4™<ó¼3¾´cÌÈRABLå›;‹ MOÂ@†ïû+Þ%¡IëG¢-¬ˆ¶5rðäN»
l,
iwý÷Ò(zÐCç4™<ó¼3¾´cÌÈRABLå›;
----END RAW----


SQL query:

‹ MOÂ@†ïû+Þ%¡IëG¢-¬ˆ¶5rðäN»
l,
iwý÷Ò(zÐCç4™<ó¼3¾´cÌÈRABLå›;

MySQL said:
#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 '‹ Â