I get:
mysql> -p database < /Users/me/Desktop/database.sql;
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 '-p database < /Users/me/Desktop/database.sql' at line 1
Thanks,
TR
On Aug 22, 2004, at
Hi,
I dumped an entire db (using phpMyAdmin, MySQL 4.0.18)
I have a file now: mydb.sql
Again, this is the entire db.
Now I have recreated the db and all the tables, rows, etc.
All I need to do is to get the data (data only, db is built) that goes
into those tables and rows from the file into the
Well, a friend told me that:
"register_globals is off by default in recent versions of PHP. You need
to
refer to GET/POST variables using the $_GET or $_POST associative
arrays,
or turn register_globals on in your php.ini."
I enabled register_globals, it was Off.
However the following (see quo
Adding this file (g_common_func.php). This is 'included' by the web
form file's code along with the connection script), I thought I should
include all referenced files and forgot this one:
# g_common_func.php
# common functions to gotcha application
# display header information
function header
Here is my connection script (conn_inc.php):
if (!$connection) {
echo "Could not connect to MySQL server!";
exit;
}
$db=mysql_select_db("test_gotcha",$connection);
if (!$db) {
echo "Could not change into the database test_gotcha";
exit;
}
?>
Here is a web form (g_add_gotcha.php -- I have inse
I hope someone might be willing to help out.
I'm trying [still] to learn MySQL and php - to create some simply web
based database.
I have installed quite a few php/MySQL web database apps from books,
however, none of them will get data entered into my database.
When I create the database exact
everything you need to know and do is here:
http://www.entropy.ch/software/macosx/mysql/
On Tuesday, July 1, 2003, at 04:30 PM, Werner van Mook wrote:
Hi all,
I'm new to this list so forgive me if I tear open old wounds..;-)
I installed MySQL 4.0.13 on my mac with OS X 10.2.6
I followed the in
1 mi. = 1.609 Km.
;-)
On Sunday, June 29, 2003, at 10:37 PM, Rohan Hawthorne wrote:
We work in a largely distributed environment, with servers in the main
server room being thousands of kilometers (that's about 3/4 of a mile)
from clients.
We are hoping to set up a replication system so that sel
Thanks Salam, but a question: this would mean that I must do by hand
every record ID link, no?
Ted
On Sunday, June 29, 2003, at 02:29 AM, Salam Baker Shanawa wrote:
Hi Ted,
1. Modify the query which presents all records by selecting let's say
the peopleID.
2. When you build your update lin
I'm writing here in hopes of finding someone who uses this and might be
able to help me.
I am dealing with a recordset who's query is thus:
SELECT firstName, lastName, deptPOS, workPH, homePH, location, model,
make, propID, addressIP, OS FROM people, make, models, machines
WHERE people.peopleID
On Friday, June 27, 2003, at 02:14 AM, James Moe wrote:
On Fri, 27 Jun 2003 01:44:53 -0400, [EMAIL PROTECTED] wrote:
umm... how do I specify which "one"? (this sounds really "slow-poke"
to me, sorry.)
Use either "people.peopleID = some_specific_ID" or "models.modelID =
some_specific_ID".
I'm
Ok, this is good:
SELECT firstName, lastName, deptPOS, workPH, homePH, location, model,
make, propID, addressIP, OS FROM people, make, models, machines
WHERE people.peopleID = machines.peopleID AND make.makeID =
models.makeID AND models.modelID = machines.modelID LIMIT 1;
umm... how do I specif
Where can I learn --someplace really for dummies?-- about creating
filters and limits?
Thanks,
Ted
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Thanks everybody for all you great help!
Ok, this statement will select all of my records nicely:
SELECT firstName, lastName, deptPOS, workPH, homePH, location, model,
make, propID, addressIP, OS FROM people, make, models, machines
WHERE people.peopleID = machines.peopleID AND make.makeID =
mod
If the ID field is *not in your text file, why not take it out of the
CREATE statement and add it afterwards?
Ted
On Thursday, June 26, 2003, at 10:46 PM, Scott Haneda wrote:
I have this
CREATE TABLE `dictionary` (
`id` int(11) NOT NULL auto_increment,
`word` text NOT NULL,
`def` text N
Actually, denormalizing aside, are multiple Joins or statements like...
SELECT lastName, location, model, make
FROM people, make, models, machines
WHERE people.peopleID = machines.peopleID AND make.makeID =
models.makeID AND models.modelID = machines.modelID
...common?
I guess that's actually c
Ok, I trying to get this example... what is "table1 t1, table2 t2,
table3 t3, table4 t4", I mean, what does the t1, t2, t3, t4 represent?
If you say, table 1, table 2, etc well, I assume that, but isn't
that there already?
Let me, or may I, give ask again with my visual? Here are my table
I grown my db to 4 tables 8). I'm going to ask this plainly in hopes
that my "syntax" in ok:
I know how to SELECT * from 2 related tables and get all the records
listed in the resultset.
(Either using INNER JOIN or WHERE.) Now... and I have been looking
some books!
How do get a resultset of
I want to insert a value into a (one) field of all records in a table.
I tried:
INSERT INTO models (makeID) Values (1)
But that adds a new record, with the value filled in. I don't want a
new record, I want that value inserted into all the records of table
'models' 'makeID' field.
Thanks
n wrote:
(B
(B> Hi tlr7425,
(B>
(B> Besides what I said in my last e-mail I completely overlooked that
(B>
(B>>> SELECT * FROM machines INNER JOIN people ON
(B>>> machines.machinesID=people.peopleID;
(B>
(B> should be
(B>
(B> SELECT * FROM machine
Ok, should be this:
SELECT * FROM machines INNER JOIN people ON
machines.peopleID=people.peopleID;
Ted
This:
SELECT * FROM machines INNER JOIN people ON
machines.machinesID=people.peopleID;
Is not producing the same results as this:
SELECT lastname, model FROM people, machines WHERE machine
This:
SELECT * FROM machines INNER JOIN people ON
machines.machinesID=people.peopleID;
Is not producing the same results as this:
SELECT lastname, model FROM people, machines WHERE machines.peopleID =
people.peopleID;
Can someone please tell why, what's wrong?
(What happens is that the wrong p
On Sunday, December 15, 2002, at 10:03 PM, David T-G wrote:
% ---
% Does anyone know what NetInfo Manager means when it shows a username
% (mysql) whose passwd is "*" (an asterisk)? And how I might
incorporate
% that user into... whatever I need it for? :)
No idea here; sorry. Well, some id
Ok, got the Apple OX XS 10.2 MySQL install happening.
The ENTIRE reason I have had s many problems getting going with the
Apple installed MySQL (Mac OS XS 10.2) is because:
The MySQL Manager (/Applications/Utilities) will run the initial
'mysql_install_db' script, it may not start mysqld up
Sorry all, but I'm trying!
What is the fix for the following behavior (besides "shoot the user" ;)
---
Welcome to Darwin!
[greenroom:~] ted% safe_mysqld --user=ted &
[1] 551
[greenroom:~] ted% touch: /var/mysql/greenroom.err: Permission denied
chown: /var/mysql/greenroom.err: Operation not permitt
On Sunday, December 15, 2002, at 08:15 AM, David T-G wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
TR --
...and then [EMAIL PROTECTED] said...
%
% I wish to attempt to clarify one of my earlier questions:
That's always helpful :-)
%
% Most things I've read say to establish a "mysql" u
I wish to attempt to clarify one of my earlier questions:
Most things I've read say to establish a "mysql" user -I take it this
is to run the daemon(mysqld?) under?
Is the above user one that will be created in the users table of the
mysql db? What mysql privileges does such a user need?
Also,
Well, I think I ALMOST have figured out how to get the Apple installed
MySQL running on Mac OS X Server 10.2 (not an XServe). I have it
running but still have some issues:
(Apple installs the mysql in /usr/share as opposed to /usr/local... as
far as I can tell.)
I am having trouble with 2 thi
how exactly do I change the Root user's password for mysql?
like this? :
mysqladmin -u root -p'newpasswd' ? (without a space between -p and
'newpasswd' ?)
and, if that is correct, I guess I'd then be presented with a prompt
for the old passwd, right?
Then, the new one would take effect?
T
Is MySQL running?
Use Process Viewer to see if there is an entry for mysqld.
If not, I would ask if you issued the "install_db" command and then
started mysql.
Ted
On Monday, September 30, 2002, at 06:03 PM, Palash Mohanlal Kasodhan
wrote:
> Hi everyone,
> I am just starting to
on 8/4/02 3:13 AM, Hussein Morsy, typed:
>
>> how can i make MySQL show only what db are available to the user?
>> i.e., when a user logs in from a terminal application and types:
>> 'show databases;'
>
>
> mysqld --safe-show-database
> or in my.cnf:
> safe-show-database
>
> With this option,
how can i make MySQL show only what db are available to the user?
i.e., when a user logs in from a terminal application and types:
'show databases;'
they only are shown the db(s) they have access to.
?
Thanks
-
Before postin
how can i make MySQL show only what db are available to the user?
i.e., when a user logs in from a terminal application and types:
'show databases;'
they only are shown the db(s) they have access to.
?
Thanks
-
Before postin
i've read up and am able to add users with encrypted passwords.
what i want to do is restrict a user to a database.
in the mysql db there is the users table and the db table. i understand
that permissions in the users table override those of the db table.
so what i do is this:
1) create a user
Sorry, I know nothing about it so I'm asking... (wasn't long ago I could get
MySQL installed and running. ;-)
I'm using Mac OS X (Server).
I installed MySQL... if ODBC is not included, does anyone know where or how
I get it for OS X and MySQL?
(I've read the MyODBC site but it doesn't seem to l
I've read the Adding New Users Section and the initial and post setup
section of the manual, but I still need some clarification:
After an install and a working MySQL I see it like this (Mac OS XS):
there are 3 users:
mysql - created manually after installing MySQL and has a password
root - a mys
on 7/14/02 3:29 PM, William Bradley, typed:
> mysql> USE mysql
> ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
> mysql>
use mysql;
:)
-
Before posting, please check:
http://www.mysql.com/manual.php
though not for your OS, I'd look for clues here:
http://www.entropy.ch/software/macosx/
Ll
on 7/13/02 11:16 PM, Haany Boyke, typed:
> Hi,
> i am just installing the new mysql 3.23.51 for my
> linux 7.3.
> The problem is after unzipping the tar.gz file and
> running the mysql_install_db (which r
Thank you, I hope this is the right place to be asking these questions. If
there is a more "newbie" place please let me know. Here's more output I
need help with, I think it's self-explanatory except that I don't how to
rectify it. The following is a continuation my original message and a
reply
Can anyone translate this for me, please? TIA
Welcome to Darwin!
[zbase:~] lloyd% /usr/share/mysql/mysql.server start
[zbase:~] lloyd% touch: /Users/mysql/Documents/dbs/zbase.err: Permission
denied
chown: /Users/mysql/Documents/dbs/mbase.err: Permission denied
Starting mysqld daemon with database
Does anyone know if these instructions actually work?
(they didn't for me)
http://cerebus.sandiego.edu/~jerry/UnixTips/mysql.html
I'd like to fix them up so I and others never have to seek this out again,
tall order?
Who can help me?
after I followed these the server didn't start.
I had to use
[localhost:~] ll% ps ax | grep mysqld
349 ?? S 0:00.04 sh ./bin/safe_mysqld
385 ?? S 0:00.08 /usr/local/mysql-3.23.51/bin/mysqld
10102 std R+ 0:00.00 grep mysqld
[localhost:~] ll%
Are these "??" supposed to be there, what do they mean?
Maybe this is indicative of my problem
I've been scowering (sp?) the docs but I can't get past:
mysql> use mysql;
ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
mysql>
This happens under any condition where access is needed.
It is after I have done mysql_install_db and chown and there is a user
"mysql".
It does
oops, Mac OS X.
Lloyd
on 6/23/02 10:16 PM, Danny, typed:
> Hello,
>
> What version of UNIX are you running?
> Solaris, Linux, FreeBSD, BSDI?
>
> You can find that out my typing in uname -a
>
>
> - Original Message -
> From: <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monda
Hi,
I hope I'm at the right list!
I'm trying to start mysql -I have installed the db.
Now I'm getting the following:
[localhost:~] lloyd% sudo safe_mysqld --user=root &
[1] 630
[localhost:~] lloyd% Starting mysqld daemon with databases from
/usr/local/mysql/data
020623 20:25:20 mysqld ended
m
Does anyone know to accomplish having 'mysqld' startup at system boot on Mac
OS X 10.1.3?
(Mark Liyanage's startup item doesn't work for me, or I'm not using it
correctly.)
Thanks in Advance,
Ted Rogers
-
Before posting, pleas
but Rolf.. if i can create wouldn't that indicate permission to drop also?
thanx
At 10:01 AM +0800 2/26/01, Rolf Hopkins wrote:
>Suggestion: Check file permissions.
>
>
>- Original Message -
>From: <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Sunday, February 25, 2001 12:33
>Subje
At 8:15 PM -0700 2/25/01, Geoff Coffey wrote:
>I just installed mysql 3.23 and then ran a script to create a database I had
>previously been using in an older version. I have a couple questions.
>
>First, how can I make a drop database statement not fail if the database
>doesn't exist. A book I wa
i'm newbie.
how come i can create but cannot drop? (errno: 21)
i am root.
mysqladmin asks if i am sure... i say 'yes' and i get the same (can't
rmdir. errno: 21)
TIA
-
Before posting, please check:
http://www.mysql.com
can you please stop sending attachments through the list?
At 11:24 AM +0100 2/13/01, Irmund Thum wrote:
>Rolf Hopkins schrieb:
>>
>> "^M"??? You sure it is that? Anyway, it is most likely to do with carriage
>> returns. Windows uses CR and LF to indicate a new line, while Linux and
>> Macs
will you all be doing anything for OS X?
At 8:01 AM + 2/2/01, John Dean wrote:
>Hi
>Hopefully, we plan to include Dezign for Databases in our new GUI
>client, but this is not yet embedded in stone.
>
>At 23:54 01/02/2001 -0500, Michael Lépine wrote:
>>I've tried searching the archives, but I
where i live this is illegal.
i hope these jerks don't have my email address.
can you do anything about this TEnon?
At 11:14 PM -0500 2/1/01, <[EMAIL PROTECTED]> wrote:
>New Concept in Gifting!
>Join A Team Of 6 And 7 Figure Earners
>
>The sole purpose of this Activity is to enable us to bless m
anyone know any ER Design tools for Macintosh?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROT
i too am interested, especially for the Mac.
pleasepleasepleaseplease
At 5:14 PM -0800 1/31/01, David Wilde wrote:
>Has anyone ever been able to get ER/Studio to work with MySQL? Are there
>any other database design tools such as ER/Studio that support MySQL
>directly? Is this a project for sou
from the MySQL site is MySQLGUI.
will this run on OS X pb?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail
can one 'get in' and control MySQL through OS X pb's Terminal app?
(various Unix shells.)
i think i need a GUI to start though, don't you?
At 11:48 AM -0700 1/28/01, Andrei Cojocaru wrote:
>there is the mysql command-line client, it's under bin under the
>mysql
and dumb too!
if(?) there is no app to launch, i.e., no GUI (Mac OS Xpb) -how do i
manipulate MySQL?
if you say "RTFM" -where is that? or a site perhaps?
thank you.
(seems kind of broad for a list archive search.)
p.s. i know there are front-end GUIs available, which do you folks
recommend?
if your going to view it with a browser why not include the browser
on the CD? and set the home to the first page?
At 10:02 AM +0100 1/25/01, Bernd Kulawik wrote:
>Good morning,
>
>we want to create a bibliographical database with ca. 500.000 entries and a
>very simple structure (3 tables) to pu
is this the proper comparison:
MySQL and Cold Fusion Server (not CF Studio)?
i just started a database class (relational/ODBC) -they will of
course, eventually, use CF and Access... only a little -it's a
general class.
i, of course:), wish to resist those!
i run OS X pb.
one kindly friend was
59 matches
Mail list logo
