1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Help me clean my database by following this tutorial

Discussion in 'Databases' started by BackY, Feb 20, 2013.

  1. #1
    Can someone pls help me do these steps from this tutorial:
    Code (Text):
    1. http://blogsuccessjournal.com/blog-tips-and-advice/wordpress-tips-advice/seeing-weird-characters-on-blog-how-to-fix-wordpress-character-encoding-latin1-to-utf8/
    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?
    BackY, Feb 20, 2013 IP
  2. Rukbat

    Rukbat Well-Known Member

    Messages:
    2,883
    Likes Received:
    33
    Best Answers:
    51
    Trophy Points:
    100
    #2
    Run them on the Linux command line.
    Rukbat, Feb 23, 2013 IP
  3. BackY

    BackY Greenhorn

    Messages:
    36
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    6
    #3
    You mean putty?
    Where should I get to first, which location, or execute them right after I log in?
    BackY, Feb 23, 2013 IP
  4. amrush

    amrush Active Member

    Messages:
    29
    Likes Received:
    2
    Best Answers:
    2
    Trophy Points:
    53
    #4
    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.

    Code (Text):
    1. 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
    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
    amrush, Feb 23, 2013 IP
    Colleen likes this.
  5. BackY

    BackY Greenhorn

    Messages:
    36
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    6
    #5
    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.
    BackY, Feb 24, 2013 IP
  6. BackY

    BackY Greenhorn

    Messages:
    36
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    6
    #6
    I'm facing problems /:

    checking the log files, gives me:
    mysqldump: Got error: 1049: Unknown database 'the_database_password' when selecting the database
    BackY, Feb 25, 2013 IP
  7. amrush

    amrush Active Member

    Messages:
    29
    Likes Received:
    2
    Best Answers:
    2
    Trophy Points:
    53
    #7
    Code (Text):
    1. http://bugs.mysql.com/bug.php?id=65589
    check this link..may b it can help you...!

    regards,

    --amrush
    amrush, Feb 25, 2013 IP