MYSQL :: I Want To Make Transfer Data Between MySQL Server To MySQL Local .

Can't Connect To Local MySQL Server Through Socket '/home/data/mysql/mysql.sock' (13)
I just installed mysql on linux. If I open a terminal, su to root,
then type "mysql", I am able to connect to the server and run my
queries.

If I exit out of su so that I am my own id (baisley) and type "mysql",
I get this error: Can't connect to local MySQL server through socket
'/home/data/mysql/mysql.sock' (13)

Any idea why? mysql.sock has full permissions (read/write/execute), so
it should be accessable by user baisley. If I am baisley and I run
"mysql -u mysql" (as mysql is the user that the RPM set up), it will
connect.

What I would like to be able to do is run this without having to be
user mysql all the time. How do I go about setting that up, or is it
better to run all my queries/make tables as 1 user?

Transfer Web MYSQL Entries To Local Mysql
I've got this online mysql database that stores form entries. I wanna transfer any new entries it receives to a local sql database on a computer. I heard that SOAP might be the way to do this, though i'm not very familiar with it and tutorials can be confusing. Any advice, is this easy or difficult?

Data Transfer From One Server To Another
I want to transfer large amount of data in mysql from one unix server to another unix server which is hosting mysql as well.how can i do that?

Transfer And Set Mysql Onto The Server
well,just got some php codes and wanted to try to make them work on my server.but since that i am a newbie for all these things,i just dont know how to make them work.well,the current situation is that i have transfered all the php files to my server already,and when i ran one of the files which was called as "install.php" it just asked me to set the password,the datebase,the host and the name of the database.and no matter what i typed there it always said that there was an error when trying to connect the database.

ERROR 2002 (HY000): Can't Connect To Local MySQL Server Through Socket '/var/lib/mysql/mysql.sock' (13)
I have a problem connecting to sql and can't find anything on the net to solve the problem.

I have some sql databases running on a server. when I'm root on the server and I want to login to sql I do "mysql -ustudent -p -Dwordnet30 and it works fine. when I'm logged in with the user account on the server, i get this error message:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)

so with the same user name in mysql, i can log on when i'm root, but not when i'm the user. the grant table for the user looks like this: Code:

MySQl Data Transfer
i want to transfer a huge amount of data which is maintained over
windows running PHPTriad. PHPTriad can dump data and schema/structure
into a text file.

now i want to transfer this data to Red Hat Linux 7.2 running
APACH/PHP/MYSQL.

How To Transfer Data From Excel To Mysql?
I got a huge list of data in excel(7000 records). I want to transfer it to mysql database. Could any one show me how to do it using a fast and easy method.

Warning: Mysql_query(): Can't Connect To Local MySQL Server Through Socket '/tmp/mysql.sock' (2)
I'm trying to connect to my MySQL database (sitehosted by GoDaddy) using PHP. I am having these errors and don't understand what they mean

Warning: mysql_query(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /home/content/n/l/a/nladmin/html/v5.0_3/c_register.php on line 6
Warning: mysql_query(): A link to the server could not be established in /home/content/n/l/a/nladmin/html/v5.0_3/c_register.php on line 6

Notice: Query: SELECT * FROM types MySQL error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /home/content/n/l/a/nladmin/html/v5.0_3/c_register.php on line 6
here4
Warning: mysql_close(): no MySQL-Link resource supplied in /home/content/n/l/a/nladmin/html/v5.0_3/c_register.php on line 13

I've checked paths and connection settings and don't see any problems. My guess is now that the problem is coming from the opening and closing of the DB. my script, c_register.php uses a require_once('../mysql_connect.php') to open the connection to the database. But I also have a function definition in c_register.php that uses require_once('../mysql_connect.php') when called because it needs a connection to the DB. Here's a visual that might help:

ERROR 2002 (HY000): Can't Connect To Local MySQL Server Through Socket '/tmp/mysql.sock' (2)
I want to user ports to install phpBB
But I found that phpBB doesn't support mysql 5.x (but the ports
installed mySQL 5.0.0 alpha)

so I deinstall mysql5-server and mysql5-client
And then I install mysql41-server and mysql41-client on FreeBSD 5.3 by
ports but now , mysql is not workable Code:

Best Way To Move Data Between Internet And Local Server?
I want to be able to update my Internet server data with local data or
back up data to my local, what is the best way. Does just copying
mysql folders via ftp work?

Can't Connect To Local MySQL Server Through Socket '/tmp/mysql.sock' (2)
I have this error whe I'm trying to connect MySQL from PHP. But I can connect with Query Browser or some other software.
Why I get this error? How can I fix this?

Can't Connect To Local MySQL Server Through Socket '/tmp/mysql.sock' (46)
Can't connect to local MySQL server through socket '/tmp/mysql.sock' (46)

I get this error when I try to communicate with a table I made using a text file ...

Can't Connect To Local MySQL Server Through Socket '/tmp/mysql.sock' (2)
I am using a Mac running Mac OS X 10.4.8 and I have successfully installed MySQL on it but when I go to run it using the command

sudo ./bin/mysqld_safe &

all it does is display a random dumber and when I try the command

./bin/mysqlshow -u root -p

I get an error message saying

Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Mac OS 10.3 -- Can't Connect To Local MySQL Server Through Socket '/tmp/mysql.sock'
I just downloaded & installed MYSQL. It seemed to work and I can start
it and enter my password and change a directory but that is about all.
I have been ready and playing "hit & miss" all afternoon and it seems
to have something to do with the "mysql_install_db" not being
installed correctly -- I have tried multiple installs with multiple
downloaws.

My log. . .

Can't Connect To Local MySQL Server Through Socket '/tmp/mysql.sock'
I've installed MySQL-4.0.14 under RedHat 8, using both rpm's and compiling
from source. When I try to run MySQL, I get the following error: Can't
connect to local MySQL server through socket '/tmp/mysql.sock'

After much searching on Google, and reading many newsgroup threads on this
error, as well as reading the manual, I'm still stumped. Most of the
advice I've found suggests that the path to mysql.sock is wrong, which
makes sense, but I don't have the file mysql.sock anywhere on my machine,
so obviously I can't correct the path.

Can't Connect To Local MySQL Server Through Socket '/tmp/mysql.sock' (2)
I just got mysql 5, from mysql 3 or 4 (can't remember it's been so long). I can't seem to get a connection. I searched and found http://dev.mysql.com/doc/refman/5.0/en/unix-post-installation.html#starting-server

Here is what it says to do, I don't know enough to be able to follow. Please advise:

If you have problems starting the server, here are some things to try:

* Check the error log to see why the server does not start.
ME: How? Where?
* Specify any special options needed by the storage engines you are using.
* Make sure that the server knows where to find the data directory.
ME: How?
* Make sure that the server can access the data directory. The ownership and permissions of the data directory and its contents must be set such that the server can read and modify them.

MySQL-error : Can't Connect To Local Mysql Server Through Socket
On a freshly installed Fedora C3 (incl. webserver apache php mysql) i get
the following problem when connecting to mysql through a browser
(phpMyAdmin)::

#2002 Can't connect to local MySQL server through socket
/var/lib/mysql/mysql.sock

On the website of MySQL this error is mentioned but I found no solution.

In /var/log/messages the following log occurs :
localhost kernel: audit(....): avc: denied {write}for pid=2458
exe=/usr/sbin/httpd name=mysql.sock dev=hda13 ...

What I have tried :

- mysql.sock is srwxrwxrwx, seems ok, but dont know what the s stands for
- the dir /var/lib/mysql was drwxr-xr-x and I changed it to drwxrwxrwx : no
effect
- tried different version of phpMyAdmin : same error
- installed my website and got the following error : No connection possible
with database (in the next version I will improve the error-messages)
- through commandline there is no problem in connecting to mysql (log in,
create databases, inserts, deletes, uploading dumps, making dumps, ....)

What is the solution or what else can I try ?

Local MySQL Server
I keep getting this error everytime i try to use Mysql on my FreeBSD 5.4. I cant locate '/tmp/mysql.sock' nor my.cnf.

Mysql Can't Connect To Local MySQL Server Through Socket ...
does anybody know what exact problem mysql has when dieing by "mysql Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'"

i encountered this problem when working on a huge xml file (~8megs) and it totally stunned my mysql server. myadmin throws the same error message now (#2002 - Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock')

any ideas? maybe it's just an adjustment to the my.ini ...

Can't Connect To Local MySQL Server Through Socket '/var/lib/mysql/mys
First of all, the mySQL server is running inside a Smoothwall firewall. I am using a DMZ Pinhole to port 3306 from a webserver with public internet access, to the mySQL Mandrake 10.1 linux box inside the firewall on the internal LAN.

I am using mySQL v4.0.20

When I try to connect to the mySQL database, via HTTP only, from ANY other machine other than the mySQL server, I get the following error reported:-

Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /var/www/html/cabstatus/connection.inc on line 7
Connect Error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

I am using a PHP script to access the mySQL database:- Code:

Can't Connect To Local MySQL Server... :(
My site is getting very busy and I keep getting this error every few times I visit my site. I just hit refresh and the site loads, but how can I avoid this error from coming up? Do I need a separate mysql server? Or apache has too high loads? What is causing this?

PHP

Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (11) in

Can't Connect To Local MySQL Server
I get this error when trying to connect to a MySQL server:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

What does this mean?

By the way, anyone know of any free MySQL hosting site?
I'm trying to test connecting to a database online.
I tried Tripod and it gives me this error.

Connect To Local MySQL Server
I am trying to connect to our
remote MySQL server (which is running just fine). I have a perl script
which
worked just fine on my other Fedora 4 box (all servers are Fedora 4
with
latests updates). The one that worked fine it down and I cannot
compare
anything against it (it was a client also).

My problem is, when I try to connect to the server I get:

DBI connect('passwd','user',...) failed: Can't connect to local MySQL
server through socket '/var/lib/mysql/mysql.sock' (2) at
/home/perl_inc/mysql.pl line 19

I read all the articles I could on the subject talking about how
mysql.sock was in
/tmp and linking it etc, but on my system I did:

find / -name 'mysql.sock'

and cannot find it anywhere on my system.

My question is, on the mysql client, is there always a mysql.sock file?

Can't Connect To Local MySQL Server
I have been trying to get mysqld service running on my machine but in vain.
I downloaded source mysql-5.0.41.tar.gz from mysql.com website and uncompressed it well in
/usr/local directory.
commands that followed were
#./configure
#make
#make install

everything completed without any warnings or any errors.

But I was still unable to start mysqld service
# service mysqld start
will return :

mysqld: unrecognized service

when i just used command
#mysqld
it showd up:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

I could not find any file by that name in /tmp directory.

Can't Connect To Local MySQL Server
Some of my users report getting this error message quite often:

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (11)

I didn't get it myself, and the logs are silent on this. Do you know what could cause this error?

Can't Connect To Local MySQL Server
When trying to connect to a database or doing anything with mysql, I get
ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
I checked in /tmp and there is no mysql.sock.
I've confirmed that mysql is running

ps auxww |grep mysqld
root 40645 0.0 0.0 648 200 p5- I 12Apr05 0:00.04 /bin/sh ./mysqld_safe
mysql 40687 0.0 0.4 45756 16180 p5- S 12Apr05 19:58.11 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --pid-file=/usr/local/mysql/var/data-bus.net.pid --port=3306 --socket=/tmp/mysql.sock
root 95584 0.0 0.0 628 260 ?? S 4:59PM 0:00.00 sh -c (ps auxww |grep mysqld) 2>&1
root 95585 0.0 0.0 628 260 ?? S 4:59PM 0:00.00 sh -c (ps auxww |grep mysqld) 2>&1
root 95587 0.0 0.0 304 152 ?? R 4:59PM 0:00.00 grep mysqld

There is nothing in /var/log/messages.
The user that starts mysql does have write privelages on /tmp

Choosing A Version Of MySQL For Local Web Server
In the process of setting up a localhost web server to test things before I put them on my shared host server. Mostly I'm just dabbling - not making a living at it.

My server is Apache 2.2.3 with PHP 5.2.0 on WinXP-Pro. What version of MySQL is most compatible with these versions of server software? Can someone point me to an installation how-to doc? Would also appreciate pointers to pages I should read to familiarize myself with MySQL. I've dabbled with dbs's as standalone apps but never used one on a server before.

Can't Connect To MySql Server On Local Host
When I installed MySql on the Windows 2000 Proffessional ,it works
fine.But I followed the same installation steps in Windows 2k Advanced
Server.It gives me this error "can't connect to MySql server on local
host".It says failed to start service . I couldn't find any mysqld.exe
file in the processes list of the Task manager window.

Please tell me
steps to get mysqld.exe file appear on the task manager. Kindly let me
know the way to get mysql running.I have the Operating System on E:
drive of my computer.

Warning: Mysql_connect(): Can't Connect To Local MySQL Server
I have everything configured ready for a drupal install,

but I get this error?

Warning: mysql_connect(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /home/content/i/n/s/insidesam/html/drupal/includes/database.mysql.inc on line 31
Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

ERROR 2002: Can't Connect To Local MySQL Server Through Socket
i get this when i do '/etc/rc.d/rc.mysql start'

ERROR 2002: Can't connect to local MySQL server through socket
'/var/run/mysql/mysql.sock' (2)

ive had a look on google, and the problem for most people seems to be
permissions, but im running as root, and the socket doesn't exist. It
doesn't create the socket when it runs, because i tried putting mysql in
the root user group.

ERROR 2002: Can't Connect To Local MySQL Server Through Socket
I'm running debian 3.1 unstable. MySQL was working fine for a long time. Then I started getting this error:

ERROR 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

I tried uninstalling, and reinstalling. Still getting the same error.

Backup/Restore Mysql Database From Remote Server To Local Pc
Im trying to download mysql database "dbproducts1" which is residing in my webhost's server (Linux). From telnet i backed up using "mysqldump -u -p dbproducts1 > dbproducts1.sql"

Then i downloaded this file via ftp to my local pc(WinXP). Now on my local pc to restore database i went to command prompt and i did following:

mysql -u -p dbproducts1 < dbproducts1.sql

I got following error:

ERROR 1064 (42000) at line 380: You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right syntax to use

near '-workshop (
title varchar(250) NOT NULL default '',
decription longtext NOT ' at line 1

I opened the phpmyadmin and found that dbproducts1 database was restored but with only few tables i.e. not all tables in the db was restored.

Can somebody please help me to backup/restore this database. I checked the mysql server version and found following:

server version: 5.0.24a-community in my local winxp pc
server version: 3.23.36 in my webhost's server (Linux)

Error 2002: Cant Connect To Local MySQL Server Through Socket
Well that's the error I'm getting when trying to connect to my MySQL database, more specifically:

Error 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

I know the PHP is fine because it's a straight copy and paste from a site I wrote before that's working fine (on the same host as well no less), anyway I did a bit of Googling and all the results that came up said that it's a configuration issue and can be resolved in several ways (mysql daemon, the my.cnf file etc etc) only problem is I'm on a shared hosting service so I don't have access to this.

Does anyone know of any other potential cause to this problem other than configuration issues or is it just a call up the host deal?

ERROR 2002 (HY000): Can't Connect To Local MySQL Server Through Socket
I'm trying to run MySQL, and sadly I've not had a lot of success. I'm running on a brand new Macbook (Mac OS X 10.4 - Intel). I've downloaded both MySQL 4.1 and 5.0 in attempts to run them. Both have installed (using .dmg packages), but neither has actually managed to run.

I've been trying to troubleshoot the problem for hours now. Originally the error was:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

(( note the difference between "/tmp" and the current "/var/lib/mysql" ))

Basically, I've had lots of references to go ahead and change the my.cnf file in /etc (which at first didn't even exist... I had to copy that from somewhere else, too), as well as to search for the completely inexistent mysql.sock file that's supposedly on my drive (though I cannot seem to find it).

Furthermore, I don't even have a /var/lib directory on my computer, much less a /var/lib/mysql. I don't know if I've installed something improperly or what.

LOAD DATA LOCAL INFILE MySQL Command
Has anyone had any luck using the "LOAD DATA LOCAL INFILE" command with MySQL++? The query string shown below executes without any problems when using MySQL Query Browser (Version 1.1.18).

LOAD DATA LOCAL INFILE 'c:aAZ_combined.dat' INTO TABLE stocks FIELDS TERMINATED BY ',';

However, when I try to use this very same command in Visual C++ 7.1 using MySQL++, the command doesn't execute, and error_code is set to "1".

error_code = mysql_query(pConnection,"LOAD DATA LOCAL INFILE 'c:aAZ_combined.dat' INTO TABLE stocks FIELDS TERMINATED BY ','");

Is there something special that I have to do to get this particular command to work properly? Note that I have gotten other commands to work just fine in Visual Studio 7.1 using MySQl++. For instance:

error_code = mysql_query(pConnection,"CREATE TABLE stocks (ticker CHAR(7), date INT, open FLOAT(2) UNSIGNED, high FLOAT(2) UNSIGNED, low FLOAT(2) UNSIGNED, close FLOAT(2) UNSIGNED, volume FLOAT(2) UNSIGNED)");

This command worked in the same fashion that it did when using MySQL Query Browser. Can anyone offer any insight into what I'm doing wrong here?

Transfer Table From One Server To Another
I am having table on my local machine in a database and i want the table and allits contents to be shifted to the main server.the table contains rows above 400000 and there are almost 23 coloumns. whenever i try to import or export the table there arises an error that the primary filegroup is full and due to this error the table doesnot get transfered .Kindly suggest me some easy and help ful way so that the data transfer is fast and efficient.

Transfer Database To Other Server
I am trying to transfer my files from my other webhosting company and I have
problem on the database transfer I get the message to change this in the
database "DEFAULT CHARSET=latin1" ' Error whilst restoring DB MySQL.

Continuous Binary Log Transfer To Backup Server
I have mysql replication set up and the relay file on the slave server is updated instantly every time a change is made on the master. This is fantastic!

Now, what would work even better for me is if the relay file were continuously updated without actually performing the database changes to the slave. This way my backup server does not need to be bogged down with database operations and can do other things or not require as much hardware to keep up with the master.

I tried SLAVE STOP; but noticed that this prevents the relay file from being updated at all. (SLAVE START; resumed the updating of the relay file) So SLAVE STOP; won't work.

I am sure there is a "best" solution for this out there and I'm even more sure that this great community has the answer!

Creating A FTP Server/pages For File Transfer
I've never worked with MySQL before. I need to create a FTP logon page for clients, I'm not sure that MySQL is even the best solution f ro what I want to achieve, but I would appreciate it if someone could give me some advice.

An example of what I want to do is at: http://www.rtfacts.co.uk/page2.htm From here click on "Contact us" on the next screen you will see "Click here to go to our FTP site". This is what I want to achieve. Can I achieve this using MySQL or is there an easier way?

The hosting service I use provides MySQL services, so I can set up a database if I need to.

Data Transfer Using Sql
ok so I have a bunch of records in a database. They are identified by unique ids. I need the rest of the data from that record to transfer to the page and I do not have the slightest on how to do it.
here is my code

<?php
mysql_connect ('localhost', 'webapps', 'scr1ptacc3ss') or die (mysql_error());
@mysql_select_db(helpdesk) or die (mysql_error());
function getBuilding($campus){
$result = mysql_query("SELECT description FROM building WHERE campus='".$campus."' ORDER BY description");
while($each = mysql_fetch_array($result))......................................

Transfer Of Data
I want to transfer some columns of data to another table.
How can I do that with single query?

Data Transfer
i didnt found a way to describe what i want and tried to use the search but i think i was searching for the wrong keywords.
any way this is what i was wondering:

i have the table A and B with:
id,time,msg

table B is a blocked table where every new insert goes to first.
then if approved it gets moved to table A.
i was wondering if there is a way to read the 'id X' from table B and insert into table A with one single query.
Like:

SELECT * FROM b WHERE id = x THEN INSERT INTO a WHAT WAS RETURNED

Data Base Transfer
Im trying to learn if it is possible to transfer data from one mysql to another with a diferent structure ie different table names etc am I beating my head against a brick wall? .... its thick enuf.

Data Transfer Services
Does anyone did DTS using MYSQL before?
thinking to migrate from MSSQL to MYSQL.. If MYSQL can do DTS, then I don't need to do scripting to transfer data.

Using Mysqldump To Transfer Data
I'm trying to transfer data from 1 table (from another database) into another table (into my database) and specify a date range somehow. To elaborate I have this employee database that has employees added every week. I'd like to grab last week's batch and transfer them into my database to display on a webpage. Last week's batch would include every employee added up to ..last friday.
Can the mysqldump command do that or do I need to write out some kinda script in order to do this?

Sharing Data Between MySQL And SQL Server
I have a client who is using SQL Server for a database over 3 geographically diverse locations. Each location has a copy of the database which is updated constantly across their WAN.

I have a single location MySQL database

We have a need to share one table between the two structures.

Is there any way that MySQL and SQLServer can share and mutually update a table between the two.

( I can't just leave the data on their server because if they take their db down, for whatever reason, the missing table will cause serious problems and effectivly shut down work on our operations. )

ERR: Data (not Date) From SQL Server To MySQL
How do I get data from my tables in SQL Server into my tables in mySQL. I have tried exporting the data out of SQL Server to a flat file (.txt), and then import into the table in mySQL from the txt. For some reason, it bombs and closes my GUI (mySQL control center).