Page 2 of 3 FirstFirst 123 LastLast
Results 11 to 20 of 22

Thread: MySQL not working

  1. #11
    Join Date
    Apr 2013
    Beans
    12

    Re: MySQL not working

    Quote Originally Posted by btindie View Post
    Type the following to see if it's actually running
    Code:
    ps -p $(pgrep -x mysqld) -f
    You can check the status of the daemon with
    Code:
    sudo service mysql status
    If it's appears to not be running then try starting it manually with
    Code:
    sudo service mysql start
    it should provide output indicating if it started OK or not.

    You can run the first two commands again to confirm it's running and also
    Code:
    ls -l /var/run/mysqld/mysqld.sock
    to check that it's created the UNIX domain socket.
    Thanks but when I type
    ps -p $(pgrep -x mysqld) -f
    I get Process ID list syntax error..
    By typing
    sudo service mysql status
    I get mysql stop/waiting
    And when I typed
    ls -l /var/run/mysqld/mysqld.sock
    I got No such file or directory..

  2. #12
    Join Date
    Apr 2013
    Beans
    12

    Re: MySQL not working

    *BUMP*!!!
    Can you please help me?
    I think that I am going to reinstall my VPS but for that I need to backup my databases, can you tell me where are they located?

  3. #13
    Join Date
    Nov 2008
    Location
    Metro Boston
    Beans
    12,791
    Distro
    Kubuntu 14.04 Trusty Tahr

    Re: MySQL not working

    They are in /var/lib/mysql. I recovered a server for a client in the same situation. First, back up this directory. Next, on the new server install mysql, and back up the /var/lib/mysql directory it creates just for good measure. Now stop the new mysql server with "sudo service mysql stop", move /var/lib/mysql to /var/lib/mysql.bak, then copy over the old directory, and restart mysql with "sudo service mysql start". That worked for me.

    You should learn how to use mysqldump to create backups of your database. I make a backup every day and copy it to a remote location over the Internet for safe keeping. You'll need to write a little script that you can run with cron. I posted one here; you're welcome to give it a try.
    Last edited by SeijiSensei; April 3rd, 2013 at 02:40 PM.
    If you ask for help, do not abandon your request. Please have the courtesy to check for responses and thank the people who helped you.

    Blog · Linode System Administration Guides · Android Apps for Ubuntu Users

  4. #14
    Join Date
    Apr 2013
    Beans
    12

    Re: MySQL not working

    Thank you very much for your reply.
    I am going to reinstall my VPS..
    But there is just one little problem, i don't have backup space, so can anybody who has 1 GB of backup space contact me in pm so i can backup my data for few hours!
    Thanks!

  5. #15
    Join Date
    Nov 2008
    Location
    Metro Boston
    Beans
    12,791
    Distro
    Kubuntu 14.04 Trusty Tahr

    Re: MySQL not working

    Can you not copy it over the Internet with something like scp or rsync?

    When I have moved things between virtual hosts, I obtain the new host first, then copy things over the Internet between the old and new virtual machines. Don't bother reformatting this machine, just set up a new one and delete the old one when you are finished. It's a lot easier and a lot safer, too.
    If you ask for help, do not abandon your request. Please have the courtesy to check for responses and thank the people who helped you.

    Blog · Linode System Administration Guides · Android Apps for Ubuntu Users

  6. #16
    Join Date
    Apr 2013
    Beans
    12

    Re: MySQL not working

    I would do that but by host does not want to give me two VMs.. Because of that I am searching for a nice person who would like to borrow me FTP account with 1GB space so I can backup my data..

  7. #17
    Join Date
    Apr 2008
    Location
    LOCATION=/dev/random
    Beans
    5,767
    Distro
    Ubuntu Development Release

    Re: MySQL not working

    Just back it up onto your own machine, and restore it when your done.

    Do you not have 1G of space free on whatever machine you are using?
    Cheesemill

  8. #18
    Join Date
    Apr 2013
    Beans
    12

    Re: MySQL not working

    Hou don't understand..
    I have 800 GB but if I reinstall from my panel I will loose all data!!

  9. #19
    Join Date
    Apr 2008
    Location
    LOCATION=/dev/random
    Beans
    5,767
    Distro
    Ubuntu Development Release

    Re: MySQL not working

    Quote Originally Posted by TheLG View Post
    Hou don't understand..
    I have 800 GB but if I reinstall from my panel I will loose all data!!
    You said you were after 1GB of backup space.

    Just use your home computer to backup on to.
    Cheesemill

  10. #20
    Join Date
    Apr 2013
    Beans
    12

    Re: MySQL not working

    Ufg, I just looked at my backup archive and it sizes 2 GB..
    On my VPS I have about 800 GB free space, and if I reinstall it I will loose everything, all files..
    There is an option from my hosting provider so I can buy an extra backup space but it's really very very expensive! On my PC i have very slow connection and if I try to download 2 GB file and after reinstallation upload it, that may take ages! So I am asking here if anybody here has own Server/PC with FTP and fast connection so I can backup my data there just for few hours!
    Thanks again!

Page 2 of 3 FirstFirst 123 LastLast

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •