Import SQL file and replace existing
I had to find/remove a lot of formatting styles in an existing SQL file that was copied/pasted from a website into the WA Admin. I cleaned the file in Excel.
Now when I try to import the cleaned SQL file, I get this:
-- version 22.214.171.124
"-- Generation Time: Oct 08, 2015 at 05:47 PM"-- Server version: 5.5.42-cll-lve
-- PHP Version: 5.4.31
"SET SQL_MODE = ""NO_AUTO_VALUE_ON_ZERO"";" "SET time_zone = ""+00:00"";"/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
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 '"-- Generation Time: Oct 08, 2015 at 05:47 PM"
-- Server version: 5.5.42-cll-lv' at line 6
Any help is appreciated. If I can't fix this, how do I find certain content in a field, globally and replace it with something else? For example:
Find: <div aasdfkadsfkj>
Replace with: <div>
In table: products