Help me clean my database by following this tutorial

Can someone pls help me do these steps from this tutorial:

http://blogsuccessjournal.com/blog-tips-and-advice/wordpress-tips-advice/seeing-weird-characters-on-blog-how-to-fix-wordpress-character-encoding-latin1-to-utf8/

Code (markup):

I don't really understand what to do in STEP 4,5,6,7, can u please tell me where should I run those commands? I tried in phpadmin, putty (using root) and non worked lol.
Any ideas?

 

Run them on the Linux command line.

 

You mean putty?
Where should I get to first, which location, or execute them right after I log in?

 

you can run those commands using putty/ssh just after login to your linux server where mysql database is running...but don't copy paste the whole command...change the parameter like username,password,dbname, u can also specify location for backup file.

mysqldump --opt --default-character-set=latin1 --skip-extended-insert --user my_db_user_here --password my_db_name_here -r exp-my-database-latin1.sql --log-error=log-mysqldump-my-database.txt

Code (markup):

here,
my_db_user_here=your database login user name ex-root
my_db_name_here=put the database name you want to take backup as .sql file

hope this will help you

regards,

--amrush

 

Thanks sooooo much amrush, Yes I know I'll have to change those settings.
I will try it now, and get back with the results, thanks a lot again.

 

I'm facing problems /:

checking the log files, gives me:
mysqldump: Got error: 1049: Unknown database 'the_database_password' when selecting the database

 

http://bugs.mysql.com/bug.php?id=65589

Code (markup):

check this link..may b it can help you...!

regards,

--amrush