You are here

Google Chrome search engines import/export from Web Data

1 post / 0 new
p2013
Offline
Last seen: 9 years 1 month ago
Joined: 2013-01-11 10:23
Google Chrome search engines import/export from Web Data

Maybe to save someone elses time: The common backup/restore of the search engines within the SQL database Web Data does not work without hands-on this time as Google has added another column: alternate_urls VARCHAR.

So after the backup of the keywords table I added '[]' at the end of each line.

Then you can restore to the new version. If you don't do this, the search engines will not show up in the new Google Chrome Version 24.0.1312.52.

Here is the batch script I use:

@echo off

set DB_PATH=P:\software\GoogleChromePortable\Data\profile\Default
set SCRIPT=%TEMP%\sync_sql_script
set DB=%TEMP%\search_engines.sql
set DB=%DB:\=/%

cd /d %DB_PATH%

choice /n /c:12q [1 backup, 2 restore, q]
if %ERRORLEVEL% equ 1 echo .output "%DB%" > %SCRIPT% & echo .dump keywords >> %SCRIPT% & goto start
if %ERRORLEVEL% equ 2 echo DROP TABLE IF EXISTS keywords; > %SCRIPT% & echo .read "%DB%" >> %SCRIPT% & goto start
if %ERRORLEVEL% equ 3 goto end

:start
sqlite3.exe -init %SCRIPT% "Web Data" .exit
if exist %SCRIPT% del %SCRIPT%

:end