Convert SQLIte to MySql DB

[nasihere]

Command: import .sql file to mysql server mysql db_name < text_file

replace big chuck file by bash command FIND='' REPLACE="'"

needed for byte sequence error in ascii to utf conversion on OSX

export LC_CTYPE=C; export LANG=C;

sed -i "" is needed by the osx version of sed (instead of sed -i)

find . -name '*.sql' -exec sed -i "" "s|${FIND}|${REPLACE}|g" {} + `

export sqlite to mysql python script ` import re import fileinput

def this_line_is_useless(line): useless_es = [ 'BEGIN TRANSACTION', 'COMMIT', 'sqlite_sequence', 'CREATE UNIQUE INDEX', 'PRAGMA foreign_keys=OFF', ] for useless in useless_es: if re.search(useless, line): return True

def has_primary_key(line): return bool(re.search(r'PRIMARY KEY', line))

searching_for_end = False for line in fileinput.input(): if this_line_is_useless(line): continue

# this line was necessary because ''); was getting
# converted (inappropriately) to \');
if re.match(r".*, ''\);", line):
    line = re.sub(r"''\);", r'``);', line)

if re.match(r'^CREATE TABLE.*', line):
    searching_for_end = True

m = re.search('CREATE TABLE "?([a-zA-Z_]*)"?(.*)', line)
if m:
    name, sub = m.groups()
    line = "DROP TABLE IF EXISTS %(name)s;\nCREATE TABLE IF NOT EXISTS `%(name)s`%(sub)s\n"
    line = line % dict(name=name, sub=sub)
else:
    m = re.search('INSERT INTO "([a-zA-Z_]*)"(.*)', line)
    if m:
        line = 'INSERT INTO %s%s\n' % m.groups()
        line = line.replace('"', r'\"')
        line = line.replace('"', "'")
line = re.sub(r"([^'])'t'(.)", "\1THIS_IS_TRUE\2", line)
line = line.replace('THIS_IS_TRUE', '1')
line = re.sub(r"([^'])'f'(.)", "\1THIS_IS_FALSE\2", line)
line = line.replace('THIS_IS_FALSE', '0')

# Add auto_increment if it's not there since sqlite auto_increments ALL
# primary keys
if searching_for_end:
    if re.search(r"integer(?:\s+\w+)*\s*PRIMARY KEY(?:\s+\w+)*\s*,", line):
        line = line.replace("PRIMARY KEY", "PRIMARY KEY AUTO_INCREMENT")
    # replace " and ' with ` because mysql doesn't like quotes in CREATE commands
    if line.find('DEFAULT') == -1:
        line = line.replace(r'"', r'`').replace(r"'", r'`')
    else:
        parts = line.split('DEFAULT')
        parts[0] = parts[0].replace(r'"', r'`').replace(r"'", r'`')
        line = 'DEFAULT'.join(parts)

# And now we convert it back (see above)
if re.match(r".*, ``\);", line):
    line = re.sub(r'``\);', r"'');", line)

if searching_for_end and re.match(r'.*\);', line):
    searching_for_end = False

if re.match(r"CREATE INDEX", line):
    line = re.sub('"', '`', line)

print line,`

[nasihere]

import .sql file to mysql error: ERROR 1045 (28000): Access denied for user 'root@localhost'@'localhost' (using password: YES)

mysql -u username -p database_name < file.sql