errors importing a database

Print Thread

Hop To

#261877 12/11/2018 4:51 AM

Joined: Dec 2018

Posts: 32

andrewjs18

Newbie

andrewjs18

Newbie

Joined: Dec 2018

Posts: 32

hi all,

I ran a backup of my ubb.threads 7.6.0 board via phpmyadmin and when I try to upload it to a test domain via the command line interface, I keep hitting the following error:

ERROR 1064 (42000) at line 468477: You have an error in your SQL syntax; check t he manual that corresponds to your MySQL server version for the right syntax to use near '<!DOCTYPE HTML><html lang='en' dir='ltr'><head><meta charset="utf-8" / ><meta nam' at line 1

here's what line 468477 in the .sql file is:

SQL Query

<!DOCTYPE HTML><html lang='en' dir='ltr'><head><meta charset="utf-8" /><meta name="referrer" content="no-referrer" /><meta name="robots" content="noindex,nofollow" /><meta http-equiv="X-UA-Compatible" content="IE=Edge" /><style id="cfs-style">html{display: none;}</style><link rel="icon" href="favicon.ico" type="image/x-icon" /><link rel="shortcut icon" href="favicon.ico" type="image/x-icon" /><link rel="stylesheet" type="text/css" href="./themes/pmahomme/jquery/jquery-ui.css" /><link rel="stylesheet" type="text/css" href="js/codemirror/lib/codemirror.css?v=4.7.7" /><link rel="stylesheet" type="text/css" href="js/codemirror/addon/hint/show-hint.css?v=4.7.7" /><link rel="stylesheet" type="text/css" href="js/codemirror/addon/lint/lint.css?v=4.7.7" /><link rel="stylesheet" type="text/css" href="phpmyadmin.css.php?nocache=6111746217ltr&server=1" /><link rel="stylesheet" type="text/css" href="./themes/pmahomme/css/printview.css?v=4.7.7" media="print" id="printcss"/><title>somehost.com / localhost / database | phpMyAdmin</title><script data-cfasync="false" type="text/javascript" src="js/get_scripts.js.php?scripts%5B%5D=jquery/jquery.min.js&scripts%5B%5D=jquery/jquery-migrate-3.0.0.js&scripts%5B%5D=sprintf.js&scripts%5B%5D=ajax.js&scripts%5B%5D=keyhandler.js&scripts%5B%5D=jquery/jquery-ui.min.js&scripts%5B%5D=jquery/jquery.cookie.js&scripts%5B%5D=jquery/jquery.mousewheel.js&scripts%5B%5D=jquery/jquery.event.drag-2.2.js&scripts%5B%5D=jquery/jquery-ui-timepicker-addon.js&v=4.7.7"></script><script data-cfasync="false" type="text/javascript" src="js/get_scripts.js.php?scripts%5B%5D=jquery/jquery.ba-hashchange-1.3.js&scripts%5B%5D=jquery/jquery.debounce-1.0.5.js&scripts%5B%5D=menu-resizer.js&scripts%5B%5D=cross_framing_protection.js&scripts%5B%5D=rte.js&scripts%5B%5D=tracekit/tracekit.js&scripts%5B%5D=error_report.js&scripts%5B%5D=config.js&scripts%5B%5D=doclinks.js&scripts%5B%5D=functions.js&v=4.7.7"></script><script data-cfasync="false" type="text/javascript" src="js/get_scripts.js.php?scripts%5B%5D=navigation.js&scripts%5B%5D=indexes.js&scripts%5B%5D=common.js&scripts%5B%5D=page_settings.js&scripts%5B%5D=shortcuts_handler.js&scripts%5B%5D=codemirror/lib/codemirror.js&scripts%5B%5D=codemirror/mode/sql/sql.js&scripts%5B%5D=codemirror/addon/runmode/runmode.js&scripts%5B%5D=codemirror/addon/hint/show-hint.js&scripts%5B%5D=codemirror/addon/hint/sql-hint.js&v=4.7.7"></script><script data-cfasync="false" type="text/javascript" src="js/get_scripts.js.php?scripts%5B%5D=codemirror/addon/lint/lint.js&scripts%5B%5D=codemirror/addon/lint/sql-lint.js&scripts%5B%5D=console.js&v=4.7.7"></script><script data-cfasync='false' type='text/javascript' src='js/whitelist.php?v=4.7.7&token=496a11148f4b8316323c150711ad0ed5'></script><script data-cfasync='false' type='text/javascript' src='js/messages.php?l=en&v=4.7.7&token=496a11148f4b8316323c150711ad0ed5'></script><script data-cfasync='false' type='text/javascript' src='js/get_image.js.php?theme=pmahomme&v=4.7.7&token='></script><script data-cfasync="false" type="text/javascript">// <![CDATA[

possibly easier to read here: https://privatebin.net/?c043aac520cd2173#iEaPxaMDTXreQst1B+L02xBh3F7ONETe9oR165EZL9k=

I'm running mysql version 5.6 on my test server. any help is greatly appreciated!

Last edited by andrewjs18; 12/11/2018 4:55 AM.

Re: errors importing a database andrewjs18 #261878 12/11/2018 5:08 AM
Joined: Dec 2018 Posts: 32 A andrewjs18 Newbie
andrewjs18 Newbie A Joined: Dec 2018 Posts: 32	I'm wondering if there was a problem with the export from phpmyadmin...I might give it another try and see if the results are the same.

Re: errors importing a database andrewjs18 #261879 12/11/2018 12:45 PM
Joined: Jun 2006 Posts: 16,348 Likes: 124 Portland, OR; USA Gizmo
Gizmo Joined: Jun 2006 Posts: 16,348 Likes: 124 Portland, OR; USA	If your database is no larger than 50mb or so you should not use phpmyadmin to create backups; as phpmyadmin is a web script it has to use PHP parameters including maximum execution time and other limits which will kill the transaction before it can complete. You should instead create a backup via the command line interface (SSH) or another system tool (such as a backup utility in your hosting control panel). I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums. Do you need Forum Install or Upgrade Services? Forums: A Gardeners Forum, Scouters World UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps Longtime Supporter & Resident Post-A-Holic VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!

Re: errors importing a database andrewjs18 #261880 12/11/2018 5:26 PM
Joined: Dec 2003 Posts: 6,621 Likes: 84 Lutz,FL Ruben
Ruben Joined: Dec 2003 Posts: 6,621 Likes: 84 Lutz,FL	Okay , I have never had s lot of issues with exporting via phpmyadmin except for sizes in the close to or exceed gb range. But you may need to export again for a test. But import yes UBB only supports up to mysql 5.5+ requirements PHP 5.4 - 5.6 MySQL 5.5+ or MariaDB Meaning mysql 5.6 has not been tested. You may need to downgrade your test server. I assume you are using it on a local machine. We don't have enough info. xamp,wamp or what. You did create the database first correct? the file will only import to a existing database. It will not create the database. Nor the user and password. Plus when creating the database choose the same coalition. Blue Man Group There is no such thing as stupid questions. Just stupid answers

Re: errors importing a database Ruben #261883 12/11/2018 8:33 PM
Joined: Apr 2004 Posts: 1,972 Likes: 154 California isaac
isaac Joined: Apr 2004 Posts: 1,972 Likes: 154 California	Originally Posted by Ruben UBB only supports up to mysql 5.5+ requirements PHP 5.4 - 5.6 MySQL 5.5+ or MariaDB Meaning mysql 5.6 has not been tested. You may need to downgrade your test server. I believe your math is broken for today :/ UBB.threads works just fine with MySQL 5.5 or higher. the plus symbol ( + ) means 5.5 is the lowest version. Anything equal to or above 5.5 is recommended. For example, many sites, including my own, are currently on MySQL 5.6 without issues. current developer of UBB.threads php forum software current release: UBB.threads 8.0.0 // wip: UBB.threads 8.0.1 isaac @ id242.com // my forum @ CelicaHobby.com

Re: errors importing a database andrewjs18 #262118 01/26/2019 4:29 AM
Joined: Dec 2018 Posts: 32 A andrewjs18 Newbie
andrewjs18 Newbie A Joined: Dec 2018 Posts: 32	the issue was with phpmyadmin. when I did a mysqldump, I didn't have any issues uploading it!

Link Copied to Clipboard

UBB.threads PHP Forum Software Community Forums Resources and Customizing Admin Zone errors importing a database