I've just started trying to use mysql (debian/linux
4.0.24_Debian-10sarge1-log), which I'm finding quite frustrating.
I have a bunch of .csv files to try to import. They all have a first
line containing field names.
When I try load data ...
I get errors no matter what I try
mysql use
Michael Friendly wrote:
I've just started trying to use mysql (debian/linux
4.0.24_Debian-10sarge1-log), which I'm finding quite frustrating.
I have a bunch of .csv files to try to import. They all have a first
line containing field names.
When I try load data ...
I get errors no matter what
from linux Fedora, FC4:
[EMAIL PROTECTED] ~]# yum -y groupinstall 'MySQL Database'
Setting up Group Process
Setting up repositories
base 100% |=| 1.1 kB00:00
Setting up repositories
Reading repository metadata in from local files
Passing package
Got it started:
[EMAIL PROTECTED] ~]# service mysqld start
Initializing MySQL database: Installing all prepared tables
Fill help tables
ERROR: 1064 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 '' at line
Ok, I logged on to the GUI Administrator as:
root
localhost
/var/lib/mysql/mysql.sock
from my linux user account. Tad confusing, as to which root is being
referred to. If I, for instance, restart they system I'll need to
manually restart the database? Or, if for some other reason the
Hello,
Ive never worked with mysql dbs and I would like to start a new Project at
work creating a new mysql db. I start read but I got lost so many times that
I am seeking guidance help, someon to tell me first start with this and
after do that. Is anyone available to give some guidance at
Sérgio Júnior [EMAIL PROTECTED] wrote on 08/24/2005 05:43:33
AM:
Hello,
I’ve never worked with mysql db’s and I would like to start a new
Project at
work creating a new mysql db. I start read but I got lost so many times
that
I am seeking guidance help, someon to tell me first start
Sérgio Júnior wrote:
I’ve never worked with mysql db’s and I would like to start a new
Project at work creating a new mysql db. I start read but I got lost
so many times that I am seeking guidance help, someon to tell me
first start with this and after do that. Is anyone available to give
Help, please, for a beginner to mysql, but with a (long time ago) background
in 'C'.
1. I can install and get running version 4.1.11-nt of mysql. I cannot ugrade
this to version 5 - it simply will not install properly depite doing all the
things it says in the documentation. I hope to use the
Hi I'm just getting started with PHP and MySQL.
I'm confused about from where I can deliver commands etc. I'm working from a
mac OS X, can I do it from the 'Terminal' utility? Or do I need to install
something else, like PuTTY?
I've a fair idea on how to use PHP but it's combination with MySQL
Google is your friend...there are TONS of great sites and code snippets
out there.
I bought several books and found that the web and google always had
better info/articles/etc.
--s
Scott Franks
On Jan 14, 2005, at 11:21 AM, Peter O'Brien wrote:
Hi I'm just getting started with PHP and MySQL
New Riders MySQL by Paul DuBois extremely well written and
helpful. You'll even see Paul chime in on this list from time to time.
On Jan 14, 2005, at 11:21 AM, Peter O'Brien wrote:
Hi I'm just getting started with PHP and MySQL.
I'm confused about from where I can deliver commands etc. I'm working
Hello,
I have a number of databases, and associated web page files written for
the SmithMicro product WebDNA.
Basically it is a shopping cart program, but I am using it for database
driven dynamically produced web pages.
I need to convert my files to MySQL and use php web pages as the front
end
I recently installed a preconfigured package with Apache, PHP and MySQL
from Apache Friends (XAMPP). It seems to be a pretty slick package, and I
got all three programs up and running without too much trouble. Now I'm
beginning to learn about MySQL.
I finally got MySQL connected to
Prompt, then through phpMyAdmin. Each time, it knocked out phpMyAdmin,
and I had to reinstall everything from scratch. So I'm finished with
the root password.
Once you've added a root passsword you'll need to add this to the
config.inc.php (assuming you're running phpMyAdmin with conf option;
At 02:57 PM 1/22/2004, David Blomstrom wrote:
I recently installed a preconfigured package with Apache, PHP and MySQL
from Apache Friends (XAMPP). It seems to be a pretty slick package, and
I got all three programs up and running without too much trouble. Now I'm
beginning to learn about MySQL.
(Note: I've been having trouble with Eudora; I can receive mail, but I
often can't send e-mails. So I resubscribed to the MySQL list from my other
e-mail address,
http://us.f604.mail.yahoo.com/ym/[EMAIL PROTECTED]YY=19813order=downsort=datepos=0view=ahead=b[EMAIL PROTECTED],
but I haven't
Hello, I'm new to SQL and trying to start out with a relatively simple
project. I'm hoping someone can give me a few tips on how to accomplish my
goal.
I want to have a table for registered users reg_user (username, userID,
password, email, status)
I also want to have a table associated with
Hi. I'm a relative MySQL newbie.
A few weeks ago, I installed MySQL 4.0.13 on my WinXP Home box.
After some use, the system began to run very slowly, e.g, the login
box, start menu, and other apps were taking a few seconds to respond
to my mouse. Rebooting did not solve the problem.
By trial
I have two machines that I have installed red hat 8.0 on and with it
the mysql v 3.23.52. I have used admin and query tools to communicate
with both from a local machine using both localhost via unix socket and
via host name via tcp. When trying to communicate over the net from
a different machine
Hello All,
My name is Tres and I'm an experienced programmer in C/C++ and trying
to learn to program some other languages better: currently Perl and the
Tk extension set for Perl. I'm also new to relational databases. I
have usually gotten frustrated with the complexity of them and
Description:
I tried installing mySql on OS X 10.2.3, following the instructions
at http://www.entropy.ch/software/macosx/mysql/ . I wanted to set a
password for the MySQL root user , so I typed:
./bin/mysqladmin -u root password 'new-password' (with, of course, a
password in place of 'new
Jeff Spivack wrote:
Description:
I tried installing mySql on OS X 10.2.3, following the instructions at
http://www.entropy.ch/software/macosx/mysql/ . I wanted to set a
password for the MySQL root user , so I typed:
./bin/mysqladmin -u root password 'new-password' (with, of course, a
on 01/17/2003 9:25 AM, gerald_clark at [EMAIL PROTECTED]
wrote:
I tried installing mySql on OS X 10.2.3, following the instructions at
http://www.entropy.ch/software/macosx/mysql/ . I wanted to set a
password for the MySQL root user , so I typed:
There apparently is a problem with the
Hi
I have on line access databases and I query them using ASP - I often
create the initial in the access dbase and then use asp on the query and
again this method works well.
I have recently upgrade the database format to mysql but am still using
ASP which I assume is ok ?
Can I create queries
If you're asking what I think you're asking, no. You can't store your
MySQL queries the way you can with Access or SQLServer (views/stored
procedures). Your ASP scripts have to build the queries they need by
themselves.
-bill
John Berman wrote:
Hi
I have on line access databases and I query
Hi,
Iam back on this list after being diverted by job change - moving house etc.
I've just set up one of my machines with Mandrake 9.0 and went for the
included MySQL install (3.23).
When I try to do anything I get an error saying that the 'mysql.sock' could
not be found.
I remember that this
George,
Tuesday, October 15, 2002, 2:55:14 PM, you wrote:
GP Iam back on this list after being diverted by job change - moving house etc.
GP I've just set up one of my machines with Mandrake 9.0 and went for the
GP included MySQL install (3.23).
GP When I try to do anything I get an error
To: George Pitcher; [EMAIL PROTECTED]
Subject: RE: Getting started - mysql.sock error
When I try to do anything I get an error saying that the
'mysql.sock' could
not be found.
Actually, you probably got a more detailed error message than
this. Try posting the entire error message - I
George,
Tuesday, October 15, 2002, 5:09:47 PM, you wrote:
GP Its slightly difficult doing it exactly as my email is on my W2K laptop -
GP but here goes:
GP error: 'Can't connect to local MySQL server through socket
GP '/var/lib/mysql/mysql.sock' (2)'
GP Check that mysqld is running and that the
Egor,
Run
ps ax | grep mysqld
to see if mysqld is already running.
This returns '11276 pts/1S 0:00 grep mysql'
I have checked and cannot find mysql.sock anywhere.
Cheers
George
-
Before posting, please
i need help with getting started with mysql
i am a java programmer but have not done any database
stuff. i assume that mysql can be a good db to start
with java database programming ie jdbc stuff.
would you also say that mysql would be a good db to
start and learn with jdbc ? can some one let
Try the sun site - www.javasoft.com
I believe there are tutorials for JDBC.
Cheers,
Michael
-Original Message-
From: john greene [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 19, 2002 10:28 AM
To: [EMAIL PROTECTED]
Subject: getting started
i need help with getting started
Hi
Installed Mysql (from mysql-3.23.51-win.zip) to c:\mysql on my pc
(running Windows XP Professional)
Started Apache (1.3.20) that I got with mod_perl . runs ok (can do perl
scripts on it ok)
Tried to execute c:\mysql\binmysqld
(as in the manual)
after about 5 seconds, comes back with
Suresh R. Soni wrote:
Hi All,
I have good Sybase experience and I have installed
MySQL in a Linux box. Can u please answer my following
queries:
[Sammy] I like Sybase very much as well. =)
1. When I run safe_mysqld I get Starting mysqld
daemon with database from /var/lib/mysql 020314
On Friday, 15. March 2002 09:32, Sammy Lau wrote:
2. How to check if mysql server is up ?
[Sammy] trying to connect the mysqlserver is the best way to do the job.
Try: ps -ax | grep mysqld
or mysqladmin ping
Regards
Georg
Hi All,
I have good Sybase experience and I have installed
MySQL in a Linux box. Can u please answer my following
queries:
1. When I run safe_mysqld I get Starting mysqld
daemon with database from /var/lib/mysql 020314
17:00:01 mysqld ended do this mean a successfull
start or failure ?
2. How
Paul,
Okay, then try adding the --user=mysql option to the command.
I killed the server (kill -9) and brought it back up with -Sg --user=mysql:
The result:
[localhost:/usr/local/mysql] root# /usr/local/mysql/bin/mysqld -Sg
--user=mysql
--- Here came some hints
Cannot initialize InnoDB as
At 16:25 +0100 1/29/02, Lutz, Helmuth wrote:
Paul,
thanks for answering. Because of my job I have to succeed this
correspondence from within another location and machine.
Could you please give some more explaination to a bloody guy to Unix and
the terminal like me:
1)
Kill the server (kill
Paul,
I do not know why, but it did not work. Please see yourself:
This lines I could not copy and paste because the results are on a not
connected Mac and this is a windows machine. So I had to write it by hand
(- but looked 2 times at the text)
Your example:
% ps ax | grep mysql
251 ?? S
Hi,
I am trying to get MySQL 3.22 (off a CD from a manual) running on Windows
98. I have installed it on my C drive and am trying to run the following
command from DOS:
c:\mysql\binmysqld --standalone
I can get to the mysql\bin directory, but when I type the
mysqld --standalone, I get a Bad
Hi Dan,
- Original Message -
From: Dan Buckner [EMAIL PROTECTED]
I am trying to get MySQL 3.22 (off a CD from a manual) running on Windows
98. I have installed it on my C drive and am trying to run the following
command from DOS:
c:\mysql\binmysqld --standalone
I can get to the
Hi Matthew,
- Original Message -
From: "Matthew P. Marino" [EMAIL PROTECTED]
You've got a long way to go. "tar" is short for tape archive. It is an
ancient unix utility that takes directory and file data and builds it into
a
contiguous data base file. This is for portability and
Hi Everybody!
Just starting to teach myself MySql and databases.
I have the O'Reilly books on Perl DBI and Mysql, msql.
My question is this:
I am trying to install mysql on sparc sun solaris 2.7
machine. I found a binary version in the downloads
page of mysql.com (is is called Sun Solaris
et it from www.sunfreeware.com
hth.
-ravi
-Original Message-
From: Simon Chan [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 18, 2001 12:48 PM
To: [EMAIL PROTECTED]
Subject: getting started...the hardest part
Hi Everybody!
Just starting to teach myself MySql and databases.
I have th
You've got a long way to go. "tar" is short for tape archive. It is an
ancient unix utility that takes directory and file data and builds it into a
contiguous data base file. This is for portability and manageability. You should
have to get past "gzip" before you get to "tar". gzip is a gnu
Simon,
Take a look at www.sunfreeware.com. Go to their Downloading/Installation
section (left panel) and grab the pkg-get script. Use pkgadd to install
it. (as root: pkgadd -d BOLTpget.pkg ). Then add /usr/local/bin to your
path. (PATH=$PATH:/usr/local/bin; export PATH)
Use pkg-get to
Statically Compiled MySQLGUI 1.7.4
../Downloads/mysqlgui/mysqlgui-linux-static-1.7.4.tar.gz
I need to know whether I have to compile or do anything else with the above other than
download and unzip it. When I do that (into c:\mysql\ directory) the file mysqlgui is
not an application file so
Dillon, John writes:
Statically Compiled MySQLGUI 1.7.4
../Downloads/mysqlgui/mysqlgui-linux-static-1.7.4.tar.gz
I need to know whether I have to compile or do anything else with the above other
than download and unzip it. When I do that (into c:\mysql\ directory) the file
mysqlgui
49 matches
Mail list logo