The Little Guy Posted July 24, 2007 Author Share Posted July 24, 2007 when I type in ps aux|grep mysqld, nothing happens, except a new blank line appears waiting for input. I can run phpmyadmin, and my website connects to the database fine too. character sets dir /data/mysql/esary/share/mysql/charsets/ basedir /data/mysql/esary/ datadir /dh/mysql/esary/data/ socket /tmp/mysql.esary.sock tmpdir /tmp/ Quote Link to comment https://forums.phpfreaks.com/topic/61182-solved-run-sql/page/2/#findComment-306597 Share on other sites More sharing options...
Wildbug Posted July 24, 2007 Share Posted July 24, 2007 when I type in ps aux|grep mysqld, nothing happens, except a new blank line appears waiting for input. From the shell prompt or the MySQL prompt? I meant run it in bash. But not matter.... I can run phpmyadmin, and my website connects to the database fine too. character sets dir /data/mysql/esary/share/mysql/charsets/ basedir /data/mysql/esary/ datadir /dh/mysql/esary/data/ socket /tmp/mysql.esary.sock tmpdir /tmp/ Try adding the --socket=/tmp/mysql.esary.sock to the mysql command. Quote Link to comment https://forums.phpfreaks.com/topic/61182-solved-run-sql/page/2/#findComment-306605 Share on other sites More sharing options...
The Little Guy Posted July 24, 2007 Author Share Posted July 24, 2007 Nope... That didn't work either /usr/bin/mysql publicsize --socket=/tmp/mysql.esary.sock --user=limited --password='rmn!!2233' < /home/ryannaddy/cron/logOut.sql /usr/bin/mysql --socket=/tmp/mysql.esary.sock publicsize --user=limited --password='rmn!!2233' < /home/ryannaddy/cron/logOut.sql Quote Link to comment https://forums.phpfreaks.com/topic/61182-solved-run-sql/page/2/#findComment-306671 Share on other sites More sharing options...
Wildbug Posted July 25, 2007 Share Posted July 25, 2007 Do you get a message? Do share. Quote Link to comment https://forums.phpfreaks.com/topic/61182-solved-run-sql/page/2/#findComment-307149 Share on other sites More sharing options...
The Little Guy Posted July 28, 2007 Author Share Posted July 28, 2007 Both say: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.esary.sock' (2) Quote Link to comment https://forums.phpfreaks.com/topic/61182-solved-run-sql/page/2/#findComment-309389 Share on other sites More sharing options...
The Little Guy Posted July 30, 2007 Author Share Posted July 30, 2007 Anything? Quote Link to comment https://forums.phpfreaks.com/topic/61182-solved-run-sql/page/2/#findComment-310682 Share on other sites More sharing options...
The Little Guy Posted July 31, 2007 Author Share Posted July 31, 2007 Anyone? Quote Link to comment https://forums.phpfreaks.com/topic/61182-solved-run-sql/page/2/#findComment-312144 Share on other sites More sharing options...
Wildbug Posted July 31, 2007 Share Posted July 31, 2007 You're going to have to find a way to connect to the MySQL server. If it's not running on your host (run "ps aux|grep mysqld" to verify), then you can't use a socket. I'm not sure how your ISP has things set up, so normal things might not work. How do you connect to MySQL in your PHP programs? You might try using the --host= option to connect if it's on a different host than localhost. Quote Link to comment https://forums.phpfreaks.com/topic/61182-solved-run-sql/page/2/#findComment-312155 Share on other sites More sharing options...
The Little Guy Posted August 1, 2007 Author Share Posted August 1, 2007 Got it! Final result: /usr/bin/mysql -hmysql.tzfiles.com publicsize --user=limited --password='rmn!!2233' < /home/ryannaddy/cron/logOut.sql Quote Link to comment https://forums.phpfreaks.com/topic/61182-solved-run-sql/page/2/#findComment-312889 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.