i would like to know how to write batch script for dumping schema and
data into a sql file. This script should dump the whole database and
data
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
SPAM ALERT
-Original Message-
From: va ku [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 08, 2002 11:04 AM
To: [EMAIL PROTECTED]
Subject: mysql
mysql
See Dave Matthews Band live or win a signed guitar
http://r.lycos.com/r/bmgfly_mail_dmb/http://win.ipromotions.com/lycos_02
0201/s
I agree with everyone that has responded. A vague answer that does
nothing but moan about something that is more or less incompentence from
your developmental team. Not only that, but you have a support
contract, so why you asking a question here? Shouldn't you be calling
your support for this
I agree with Chris...
Writing a book on features that do not exist yet is asking for trouble.
-Original Message-
From: Christopher Thompson [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 12:00 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: MySQL Book
On Friday 05 A
Wow John... Sounds like you are in deep chit... Just kidding... Linux 6
doesn't say which distro it is, same with mysql 3, there are a bunch of
mysql version3s out there.
Your problem...
Log into as root then restart it.
-Original Message-
From: john [mailto:[EMAIL PROTECTED]]
Sent:
Im going to take a shot in the dark since I have not messed with ASP in
years
Have you just tried to verify the data is there with a simpler script?
Just do the connection script then the user_check then see if it is
still there. If it was PHP I would be able to find it.
-Original Messa
How about newsgroups for php? They have a couple on php/mysql I
believe and they respond quite quickly... Look at php.net
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 02, 2002 12:12 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE:
Yes, mySQL is up to the task. Just make sure you design the DB with
fast retrivals in mind
-Original Message-
From: Zhao, Charles [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 01, 2002 3:53 PM
To: '[EMAIL PROTECTED]'
Subject: Beginners Question
Hello there,
I am trying to find which
query");
While ($row =mysql_fetch_arrary($result)) {
$sql2 = "DELETE FROM messages WHERE topicid = $row ="[0]" ";
}
-Original Message-
From: Todd Williamsen [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 29, 2002 6:47 PM
To: 'sunny'; 'Rodney B
Sunny... Pay close attention.. You are trying to execute a query that
is a bit complex for someone new to mySQL and PHP.
$sql =" SELECT messages.topicid
FROM messages
LEFT OUTER JOIN main
ON messages.topicid=main.topicid
WHERE main.topicid = 'NULL'
$result = @mysq
Here:
mailto:[EMAIL PROTECTED]]
Sent: Friday, March 29, 2002 6:18 PM
To: Rodney Broom; [EMAIL PROTECTED]
Subject: Re: Why does my delete not work :(
So you're saying there's no actual DELETE statement for this? There is
no
way in hell I can write any SQL to do that?? Thats sucks... :(
T
You need to use the use command
Mysql> \u [databasename]
Now you may run the query
Mysql> select * FROM dbname.table;
-Original Message-
From: David yahoo [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 4:25 PM
Cc: [EMAIL PROTECTED]
Subject: pb while querying in strange db n
Harry,
It is you need to make a WEB front end to access it
-Original Message-
From: Harry Rorarius [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 10:49 AM
To: Mysql list
Subject: hmm
ok
I thought Mysql was a server that could be used as a online database?
If it is, is ther
Yes, my hosting providers use raq servers and I have mysql databases on
all of my domains
-Original Message-
From: Denis Croombs [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 27, 2002 8:30 AM
To: Mysql (E-mail)
Subject: MYSQL on a Cobalt RaQ4
Hi
Will MySQL run on a Cobalt RaQ4 ser
The problem is PHP and IIS... IIS takes a lot to get it to work... I
think you should ask sourceforge about it, not the mysql mailing list.
This is a PHP issue not a mysql.
-Original Message-
From: CATRIONA GRISEWO0D [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 26, 2002 6:24 PM
To:
Read the documentation. Where is the mySQL database located? Is it on
the web server or on another machine? If its on another machine then
you put in the IP address. If its on the same machine as the Web
Server, then put in localhost
Get it?
-Original Message-
From: catriona grisewoo
Is there a reason why you are using IIS?
I would disable IIS and run apache. That's what I did, IIS is way to
difficult and unstable to install PHP as CGI or ISAPI
Apache is easy to set up with PHP. Download Apache and run PHP from
there. Make sure you disable ALL the IIS services
-Ori
Properties and select "Disable" in the
drop down box
-Original Message-
From: Andrew Hazen [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 25, 2002 12:34 PM
To: 'Todd Williamsen'
Cc: [EMAIL PROTECTED]
Subject: RE: mysql/php on Win2000
Hi, if you think that IIS and Apac
I have found Win2k completely stable with Apache/PHP/mySQL. Not one
issue!
If you are talking IIS combo, then yes issues will arise. I don't see
any performance hit on this setup as a CGI. I think you are being a bit
bias towards Windoze. Windows 2k is quite stable. The thing about
win2k is
IIS: Kill the services, and disable them If you need to know which
ones let me know.
Oracle8i: No, they use different ports. I run Oracle8, mySQL, SQL
Server7 without any problems
-Original Message-
From: Andrew Hazen [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 25, 2002 10:24
> > 7.2, Apache, mysql and php. I copied a sample php script from the
>internet
> > and save it as phptest.php in my cgi-bin. When calling it from my
>browser, I
> > got Format error. Did I not do it right? Should I put it in my
>cgi-bin?
> > Could some
Your client won't drop Access in favor of a faster, more secure database
like mySQL? Why is your client stuck on Access? The data can be dumped
and make the GUI web based to look just like the Access one... Stick in
on a Intranet server, and lock it down... I would rather have that than
a slow,
PHP
http://www.php.net/manual/en/install.linux.php
mySQL
http://www.mysql.com/doc/L/i/Linux.html
I never had any problems with mysql and PHP talking to each other on
Linux, and I am very wet behind the ears with Linux. Maybe you can give
us an error messages you are receiving, and that will g
I ran the .exe file and WHAMMO! It installed itself as a service. I
just needed to edit the service to have it automatically start at boot
-Original Message-
From: Gerald R. Jensen [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 18, 2002 6:40 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
S
Try turning the CAPs off first... Makes it easier to read...
Second...
You are using ADOB to connect to mySQL? Is that what you are doing?
Using ASP? Try using PHP, easier to learn and is much more compatible
with mySQL. ASP/mySQL can be used, but its a pain, plus ASP has its
limitation that
I didn't realize you were trying to telnet to a client. You cannot do
that. You need to telnet to the SERVER. Whatever the server is
You need to make sure the user you are trying to use has access rights
for the user for telnet
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTE
Can you telnet into anything else? How about a webserver? Try port 80
or 25 if you have a mail server. If you can't, you need to make sure
you have telnet rights
-Original Message-
From: Jianping Zhu [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 14, 2002 1:58 PM
To: [EMAIL PROTECTE
I think I read somewhere about this issue. I think it had to do with
multiple mySQL servers running concurrently.
See if there is multiple servers running using the ps command. If so,
then kill one of them. Also, when adding a user, do you select a
database first before adding a user?
Peter,
I have no idea what your front end is, and this is what will do the
actual encryption, all mysql does is holds the data. So whatever your
front end programming language is, it will have to do the encryption.
Below is the link for php encryption
http://www.php.net/manual/en/function.md5
Matthew...
Did you look into the session variables
Session_start()
Session_register()
Mysql, query
-Original Message-
From: Matthew Walker [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 08, 2002 4:49 PM
To: [EMAIL PROTECTED]; mysql list; Siulun A Sze
Subject: RE: login and logout
T
Daniel,
Usually in PHP there are some sort of syntax error before the line that
says failed.
-Original Message-
From: Daniel Negron/KBE [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 08, 2002 11:05 AM
To: [EMAIL PROTECTED]
Subject: Some PHP - mySQL help please ... new to both
I am v
Josiah..
I think you are asking the wrong mailing list for this... I am assuming
you are using PHP correct? Your explanation isn't all that clear, but I
can guess what you are trying to do. You want to have a drop down list,
but don't know what data type..
You can use VarChar or text for this
Here is a blurb from the report of the white paper
Lasso operates identically across platforms whereas with PHP,
significant functionality is lost migrating from one platform to
another. This makes it very difficult to develop on one platform and
deploy on another when using PHP. Lasso's platform
Quite hilarious...
Interesting..
Trying to compete versus PHP and they use php... Wild
Whats next PHP website using ASP?
-Original Message-
From: Jeff Kilbride [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 07, 2002 7:25 PM
To: MySQL
Subject: Re: Re: [ANN] Blue World Announces Lasso
I don't have a problem and I am using 3.23.47
-Original Message-
From: Robbie Martinez [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 07, 2002 3:51 PM
To: Gurhan Ozen
Cc: [EMAIL PROTECTED]
Subject: RE: MS-DOS Window
I tried using 'tee' in MySql but it's not working.
mysql> tee f
Hmm
Isn't price one of the the factors in doing a comparision? No matter
what project size it is, cost plays a major role. If I can save a
client $3000 by using PHP versus using Lasso, I would. It doesn't seem
Lasso has a $3000(or more) advantage over PHP/mySQL combo.
The thing is that peop
I have no problem running mySQL as a service on Win2k Server.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 07, 2002 2:35 PM
To: [EMAIL PROTECTED]
Subject: Running MySQL as Service on 2000 Server
Hi,
Anybody running MySQL on Win 2000 ser
You think Blue World getting the point yet? Maybe they are thinking
twice about spamming mailing lists with their products? Maybe a better
target is Microsoft's .NET boards since both products are about the same
price
-Original Message-
From: Jonathan Hilgeman [mailto:[EMAIL PROTECTED]]
Can you provide a NON-BIAS so-called "TRUE comparison"? I would be
curious on what Blueworld has to say. Also, why do you think the TCO is
lower with lasso than PHP? I don't get it, there is no cost to own it,
just to develop it. And if you develop with PHP correctly, then the TCO
is low.
H
It won't let you since Windows ODBC only lets you create ONE DSN per
DATABASE
-Original Message-
From: Edward Peloke [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 05, 2002 12:11 PM
To: MySql
Subject: connecting to all databases using one odbc connection..PLEASE
HELP
I asked yesterday
One more thing... What are you using to pull the data? PHP? Perl?
Etc?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 05, 2002 12:05 PM
To: [EMAIL PROTECTED]
Subject: Query help please!
I need help writing query that would give me parent ca
Do you have another table with all the birthdates in it?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 05, 2002 12:05 PM
To: [EMAIL PROTECTED]
Subject: Query help please!
I need help writing query that would give me parent categories of catI
Stephane...
What is the process you are trying to do?
In order to do commands in dos
Go to a command prompt:
C:\
Type this:
Cd \mysql\bin
Now type this:
Mysql
Now you should see this
Mysql>
Type this:
\u name of your database;
Now type in the command:
Show tables;
Make sure you foll
Which PHP version did you update to? I have noticed in PHP 4.1.1 is
more anal about syntax
-Original Message-
From: Vernon [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 28, 2002 1:30 PM
To: php-list; MySQL-list
Subject: After php udate, php pages no longer update MySQL database
The problem is that the DB resides on a Unix box and he access it
through a cgi program
-Original Message-
From: Luis Gonzalez [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 25, 2002 5:18 PM
To: [EMAIL PROTECTED]
Subject: Dumping a MySQL DB Out to Access
Hi,
First of all, I'm not a
I should have been more clear...
http://www.mysql.com/doc/m/y/mysqldump.html
-Original Message-
From: Todd Williamsen [mailto:[EMAIL PROTECTED]]
Sent: Sunday, February 24, 2002 10:03 PM
To: 'Pax'; 'MySQL'
Subject: RE: database structure script
Yes..
Yes.. Use the DUMP command
-Original Message-
From: Pax [mailto:[EMAIL PROTECTED]]
Sent: Sunday, February 24, 2002 9:25 PM
To: 'MySQL'
Subject: database structure script
Is there an easy way to create SQL script from existing database and use
it to create a new database?
Tks
Pax
Try myodbc?
-Original Message-
From: Admin [mailto:[EMAIL PROTECTED]]
Sent: Sunday, February 24, 2002 11:21 AM
To: [EMAIL PROTECTED]
Subject: migrate Microsoft Access Data into MySQL
How to migrate Microsoft .mdb Database into MySQL under Unix
environment?? Who can tell me?? Any Doc??
I don't think the manual is very amateur like. I find it very large,
somewhat imformative. I find it like hell to understand if you are a
novice
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Saturday, February 23, 2002 10:29 AM
To: savaidis; [EMAIL PROTECTED]
Su
There is three options I use:
1. Macromedia Dreamweaver UltraDev4 with a PHP plugin or extension
2. PHPEdit, its free I forget the website. Its a good IDE, but kinda
annoying editor.
3. Notepad
-Original Message-
From: Joel Wickard [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 22
No reason, you have the right idea especially if you are dealing with
multiple platforms
-Original Message-
From: Cip [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 20, 2002 8:54 AM
To: [EMAIL PROTECTED]
Subject: Inventory management system based on mysql
Hi all,
I am trying to
If you are on a Windows box, you can create a batch job for it.
If you are on Linux/Unix run a cron job
-Original Message-
From: Che WaiSam [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 19, 2002 8:19 AM
To: [EMAIL PROTECTED]
Subject: Re: About Regular Backup on MySQL
Dear Sir/Ma
In phpmyadmin
Choose the table from the list... Scroll down the main screen and you
will see this:
View Dump(schema) of table:
You will have options like Structure only, Structure and data, CSV for
MS Excel... Structure dumps the column names and all the field types...
Structure AND data
Do you mean run a query that pulls all content in a table?
OR
Something thats saves all content of a table?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Sunday, February 17, 2002 8:52 AM
To: [EMAIL PROTECTED]
Subject: How to save the table content into f
Alex,
What I do is a DUMP on the table, either the schema or data or both.
This will create a .sql file you can run again against whatever platform
you are on
-Original Message-
From: Alex Charlton [mailto:[EMAIL PROTECTED]]
Sent: Sunday, February 17, 2002 3:55 AM
To: mySQL
Subject: Fw:
The two biggest reasons why
1. Bloats the database
2. Slow at retrieving the images
-Original Message-
From: Reuben D Budiardja [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 14, 2002 9:30 AM
To: Todd Williamsen; [EMAIL PROTECTED]
Subject: Re: insert picture file in MySQL (+php
Reuben,
You can store the images into a database, but no one recommends it.
What I do, is actually store the location of the file in the database
then have PHP open it.
-Original Message-
From: Reuben D Budiardja [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 14, 2002 9:08 AM
To:
Jim,
I am still pretty wet behind my ears and I have always had problems with
picking up the logic behind programming languages, but PHP is awesome!
I had problems with the wacky structure of Visual Basic, and I hard a
hard time just reading the code of C++ and Java.
What helped me was a book
Yaniv,
Set the field of user_id to INT then make the size 10 or larger, which
will produce an ID size of up to 99. Now set it to auto
increment then set the user_id field to Primary key, this should solve
your problem, if I understand you correctly
-Original Message-
From: [EMA
I personally use PHP which it would use your familiar web browser. You
can also use PERL, and I believe ASP as well.
PHP is easy for a front end and doesn't take much to develop!
There is also a web based GUI for mySQL called phpmyadmin which is
awesome if you know nothing about administering
http://www.hotscripts.com
Or
http://www.scriptsearch.com
Both sites show examples on how to contect to a database with perl or
PHP. They also show how to connect to other databases!
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 12, 2002
First off, you trying to insert the image into the database or just its
path?
-Original Message-
From: yue cheng [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 06, 2002 2:23 PM
To: [EMAIL PROTECTED]
Subject: Load_File issue
Hi,
Now I am puzzled by the filepath,Load_file, I inst
First off,
You would need to add an "id" field, then set it to a primary key, then
set it to "auto_increment"
This will order them correctly
-Original Message-
From: Rich [mailto:[EMAIL PROTECTED]]
Sent: Sunday, February 10, 2002 10:31 AM
To: MySql
Subject: Duplicate Records
How does
First off, you trying to insert the image into the database or just its
path?
-Original Message-
From: yue cheng [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 06, 2002 2:23 PM
To: [EMAIL PROTECTED]
Subject: Load_File issue
Hi,
Now I am puzzled by the filepath,Load_file, I inst
Yes, the other option is to move it to a server with more bandwidth :)
Most People that are running it from home either don't know how or don't
know that they are running a firewall or have an ISP that won't let them
touch the configuration of the modem/router. So you are one of the
lucky ones.
If its so urgent and private then why are you spamming a mail list? I
smell scam, or is that Spam?
-Original Message-
From: Engr. Martin Douglas. [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 30, 2002 2:28 AM
To: [EMAIL PROTECTED]
Subject: Urgent Business Assistance.
Urgent Busi
VarChar Usually
-Original Message-
From: Vernon A Webb [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 25, 2002 9:58 AM
To: [EMAIL PROTECTED]
Subject: Re: MySQL Checkbox table field
Alright then!
> database,sql,query,table
Which field type do I use for a simply checkbox Y,N?
Tha
If its a web based DB, then put the URL path in the text field of the
DB. Otherwise if you put the images into the database, the database
will become overwhelmed, plus a bunch of wasted disk space
-Original Message-
From: Brian P. Austin [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, Januar
I would say it would take a month at least to complete the job
correctly. I have seen some top OLAP developers take 3 months to
complete a 30gb DB2 to an Essbase migration including all documentation
and politics involved. Two hours? You should be fired for just
thinking that! Just kidding. T
I agree.
I have more experience with MS SQL than mySQL, but there are some MS SQL
specifics that can cause hiccups. But these hiccups can be avoided with
a bullet proof project plan and excellent documentation. You may not be
able to automate all the project procedures and a lot of the database
Gerald...
He isn't on a Unix box, he is on a Win2k box
-Original Message-
From: Gerald Clark [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 10, 2002 8:46 AM
To: Bryan Capitano
Cc: [EMAIL PROTECTED]
Subject: Re: setting root psswd on Win2K ??
You can't login as plain old nobody.
The
I deleted it too! Guess what, I don't miss it either!
-Original Message-
From: Reports [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 09, 2002 11:12 AM
To: [EMAIL PROTECTED]
Subject: AS SEEN ON NATIONAL TV: MAKE OVER $500,000 EVERY 20 WEEKS!!
Dear Friend:
The first time I receive
Just take the shortcut out of the startup menu
-Original Message-
From: Dan Jordan [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 08, 2002 10:04 AM
To: [EMAIL PROTECTED]
Subject: Prevent WinMySQLAdmin from auto startup when windows 98 reboots
Each time that I reboot and logon to my w
I think I read something about COM+. The statement I read said it is
compatible, but I don't know about MSTDC, I would think that MSTDC would be
a Microsoft propriotary interface.
- Original Message -
From: "Patryk Choroś" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, January
You could just do this:
$result = ($sql3);
echo "$result";
- Original Message -
From: "Michael Brunson" <[EMAIL PROTECTED]>
To: "Matt Rudderham" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, January 02, 2002 1:35 PM
Subject: Re: Could you look at this PHP/MySQL Code?
> On
non data driven menus not an option? I have buit java-script menus that are
pretty cool
- Original Message -
From: "Jonathan Hilgeman" <[EMAIL PROTECTED]>
To: "'Victor Spång Arthursson'" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Wednesday, January 02, 2002 11:02 AM
Subject: RE: Imple
I found an easier way... switch the datatype to decimal, WHAMMO!! works
beautifully!
- Original Message -
From: "Steve Rapaport" <[EMAIL PROTECTED]>
To: "Todd Williamsen" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, December 29, 2001
I have a record that keeps track of averages, now when I say
SELECT * FROM tblname ORDERBY 'average' DESC;
It returns the one with the largest amount of intergers...
I.E.
It will say that 52.50 is a larger number than 358, why is that? Is that a
table column setting of a datatype?
-
I am looking to update a record in a table, but take the exsisting value and
adding the new value to it...
I.e.
Exsisting record = 150, new record being inputed = 250 for a total of 400 to
be entered into the database.
I have looked at the man pages on this but all it gives is static numbers,
LOAD DATA LOCAL INFILE "location of text file" INTO TABLE [tablename]
- Original Message -
From: "Inderpal Singh" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, December 16, 2001 8:12 AM
Subject: Location of text file for loading data in to table
> Hi,
> When using the command
Mysql>show tables;
Would be the easy way
Thank you,
Todd Williamsen, MCSE
home: 847.265.4692
Cell: 847.867.9427
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 14, 2001 10:34 AM
To: [EMAIL PROTECTED]
Subject: Table Exists
What is
end than VB or any other
programming language!
Good Luck!
Thank you,
Todd Williamsen, MCSE
home: 847.265.4692
Cell: 847.867.9427
-Original Message-
From: Rodney Broom [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 10, 2001 2:28 PM
To: [EMAIL PROTECTED]
Subject: Re: new user basic
Here is your problem:
MM_TrackoftheWolf_STRING = "dsn=DSN Name;uid=User Id;pwd=Password;"
No space between Id;pwd
Unless that is what happened when you copied and paste it
Thank you,
Todd Williamsen, MCSE
home: 847.265.4692
Cell: 847.867.9427
-Original Message-
From:
I guess I would run a query to pull the data out into a CSV file, then
import it into Excel, then convert it to a Word document. Or run a
query where MS Access pulls the data and syncs it with a database in
Access, then export the table into Excel or Word or Outlook PST file
Thank you,
Todd
into several web servers/database servers and making it into a
server farm? One server will get the snot knocked out of it with that
kind of load.
Just my $.02
Thank you,
Todd Williamsen, MCSE
home: 847.265.4692
Cell: 847.867.9427
-Original Message-
From: Philip Mak [mailto:[EMAIL
What do you mean accept new users?
Via adding new people to the MySQL user list or to a web application?
Please specify..
Thank you,
Todd Williamsen, MCSE
home: 847.265.4692
Cell: 847.867.9427
-Original Message-
From: Anthony Evans [mailto:[EMAIL PROTECTED]]
Sent: Thursday
I am going to take a stab at this...
Since MacOS X is actually an open sourced kernel, I would assume you
could use the Linux or Unix version to install it. I have not worked
with MacOS X, but if I remember correctly it had a command prompt.
Let me know if it works
Thank you,
Todd
Use myODBC to use an ODBC connection. If you are using a hosting
provider on a Unix box, more than likely this will not work
Thank you,
Todd Williamsen, MCSE
home: 847.265.4692
Cell: 847.867.9427
-Original Message-
From: dean browett [mailto:[EMAIL PROTECTED]]
Sent: Wednesday
Thank you,
Todd Williamsen, MCSE
home: 847.265.4692
Cell: 847.867.9427
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this
Sounds like you have a TCP socket problem. Is the database on a local
machine or a hosting provider? What platform is it on wintel or *nix?
Thank you,
Todd Williamsen, MCSE
home: 847.265.4692
Cell: 847.867.9427
-Original Message-
From: Georgina Fang [mailto:[EMAIL PROTECTED]]
Sent
Brian... You can SLAM yourself into a wall of confusion if you do not
pick the right books that doesn't explain things to you like a two year
old. I like books that explain things that way when I learn a new
technology. It keeps the frustration away
Thank you,
Todd Williamsen, MCSE
I bought "PHP: Fast and Easy Web Development." Its pretty through and
nice walk-throughs for a beginner. You may end up buying several
books... This book helps you get your feet wet with PHP and MySQL, but
it is no reference on everything.
Thank you,
Todd Williamsen,
Is this your email address? I can send you all the files you need.
Thank you,
Todd Williamsen, MCSE
home: 847.265.4692
Cell: 847.867.9427
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 08, 2001 6:27 PM
To: [EMAIL PROTECTED]
Subject
You can use phpadmin to control the database and there is an option to
view dump into a CSV file either in MS Excel format or standard CSV
file. Once you dumped it, you can then import it into Access
Thank you,
Todd Williamsen, MCSE
home: 847.265.4692
Cell: 847.867.9427
-Original
I have done Access to mySQL, but not the other way around... I guess
you would need to export the table to a CSV file then import it into
Access.
Thank you,
Todd Williamsen, MCSE
home: 847.265.4692
Cell: 847.867.9427
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL
I use www.ccwebhost.com for about two years... $13/mo for 200mb of space
and their tech support is beyond excellent! mySQL support, CGI-BIN,
FTP, PHP4, SSI, SSL, etc... Anything and practically everything!
Thank you,
Todd Williamsen, MCSE
home: 847.265.4692
Cell: 847.867.9427
-Original
No,
The column name should have been "Modified By" data type should have
been "text"
Thank you,
Todd Williamsen, MCSE
home: 847.265.4692
Cell: 847.867.9427
-Original Message-
From: Rick Emery [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 31, 2001 9:20 AM
default NULL,
Modified By text
) TYPE=MyISAM
MySQL said:
You have an error in your SQL syntax near 'By text
) TYPE=MyISAM' at line 19
Thank you,
Todd Williamsen, MCSE
home: 847.265.4692
Cell: 847.867.9427
--
No PHPadmin has two versions PHP3 and PHP
Thank you,
Todd Williamsen, MCSE
home: 847.265.4692
Cell: 847.867.9427
-Original Message-
From: Gonzalo Valenzuela [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 30, 2001 2:39 PM
To: Ing. Gustavo Edelstein; [EMAIL PROTECTED]; Bennett
Just my luck!
Granted I am so new to PHP I think I just eclipsed the 48 hour mark...
So am I still a rookie? Lol!!
Thank you,
Todd Williamsen, MCSE
home: 847.265.4692
Cell: 847.867.9427
-Original Message-
From: Mike [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 26, 2001 9:33
1 - 100 of 105 matches
Mail list logo