Society & Culture & Entertainment Music

How to Change a DB to a UTF-8

    • 1). Open the terminal on your computer if the database is local, otherwise log in via the secure shell (SSH).

    • 2). Type "mysqldump --user=USERNAME --password=PASSWORD --default-character-set-=latin1 --skip-set-charset DBNAME > BACKUP.sql" (without quotation marks).

    • 3). Replace all capitalized letters so they are relevant for your database and press "Enter."

    • 4). Type "chgrep latin1 utf8 BACKUP.sql" and press "Enter."

    • 5). Type "mysql --user=USERNAME --pasword=PASSWORD --execute="DROP DATABASE dbname; CREATE DATABASE dbname CHARACTER SET utf8 COLLATE ut8_general_ci;" (replacing the USERNAME, PASSWORD and both dbname's). Press "Enter."

    • 6). Type "mysql --user=USERNAME --password=PASSWORD --default-character-set=utf8 dbname < BACKUP.sql" and press "Enter."

    • 7). Type in the following code and press "Enter" to complete the process:

      sed -i "" 's/latin1/utf8/g' BACKUP.sql

SHARE
RELATED POSTS on "Society & Culture & Entertainment"
A Breeze-Through on Guitar Course Reviews
A Breeze-Through on Guitar Course Reviews
Playing Drums Melodically
Playing Drums Melodically
How To Buy A Jazz Guitar Amp
How To Buy A Jazz Guitar Amp
Music Instrument Show Your Passion About Music
Music Instrument Show Your Passion About Music
Josh Turner
Josh Turner
Beginner Drum Sets, what to look out for?
Beginner Drum Sets, what to look out for?
Fania Records - The 'Motown' of Latin Music
Fania Records - The 'Motown' of Latin Music
Easy Guitar Lessons - Online Lessons That Make Learning Guitar Easy
Easy Guitar Lessons - Online Lessons That Make Learning Guitar Easy
Online Jazz Guitar Lessons - No One Ever Regrets Having Learned Jazz!
Online Jazz Guitar Lessons - No One Ever Regrets Having Learned Jazz!
Underworld - 1992-2002
Underworld - 1992-2002
Buying Vintage Acoustic Guitars - Learn to Look for Problems!
Buying Vintage Acoustic Guitars - Learn to Look for Problems!
How to Handle Violin Lessons for Adults
How to Handle Violin Lessons for Adults
Vocal Competitions and Talent Shows - How to Pick The Right Contest and Win
Vocal Competitions and Talent Shows - How to Pick The Right Contest and Win
December 5 in Music History
December 5 in Music History
How to Play Bass Clef
How to Play Bass Clef
Single releases
Single releases
Five Very Best Beatles Tunes To Learn On Guitar
Five Very Best Beatles Tunes To Learn On Guitar
How to Site Read Measures 7-8 for Bass Guitar in Ab (A Flat)
How to Site Read Measures 7-8 for Bass Guitar in Ab (A Flat)
How to: Homemade Slit Drum
How to: Homemade Slit Drum
Scandalous Behavior: What Happens At The Afterparty, Stays At The Afterparty!
Scandalous Behavior: What Happens At The Afterparty, Stays At The Afterparty!

Leave Your Reply

*