> I have just started to use PHPMy Admin in the last hour or
> so. How do I
> upload the data and structure to a remote server. I have done a
> mysqldump and have tried to upload it but I keep getting an error.
>
> I create a statement in a window, browse to a file to upload it and
> submit
ific question to this list.
HTH
DMuey
>
>
> -Original Message-
> From: Dan Muey [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, February 04, 2004 3:33 PM
> To: Schwartz, Evelyn; [EMAIL PROTECTED]
> Subject: RE: Is there any documentation of Best
> Practices/
Sorry for the OT,
I deleted the messages from the perosn who sent me a response offlist.
In response to his personal emails in reply to:
http://lists.mysql.com/mysql/158945
he said, Perl was a write only language
(meaning it is hard to read since careless
people may do sloppy code - not me tho
> We are implementing three or four MySql servers (as a start)
> and I'm writing the Troubleshooting Guide for our operational
> staff. None of these folks have any MySQL experience (and
> I'm a newbie myself). I need a pretty basic 'Cheat Sheet' for
> troubleshooting common production type pr
> Why not use another language that has mysql hooks built in?
Good suggestion.
> For example, from version 4.3.0 PHP comes with SAPI to allow
> scripting from the command line, ideal for cron style tasks
> and it's mysql support is very mature.
Or better yet, Perl. Not only is its mysql suppor
What is the difference between 'Mac OS X downloads' and
'Mac OS X Package Installer downloads' listed at:
http://www.mysql.com/downloads/mysql-4.0.html
I know I want 'standard' and not 'max' or 'debug' but do I want
'Mac OS X downloads' or 'Mac OS X Package Installer downloads'?
What's the diffe
Howdy List,
I came across this article in the mail archives:
http://www.mail-archive.com/[EMAIL PROTECTED]/msg85864.html
And subscribed to the list because I am having the same issue.
(Hope A. Tucovic is still on the list!)
I get:
Got error 22 when trying to lock mutex in log.cc , line 1689
when
> "Dan Muey" <[EMAIL PROTECTED]> wrote:
> >> "Dan Muey" <[EMAIL PROTECTED]> wrote:
> >> > I have a table that I create with=3D20
> >> > CREATE TABLE SuperTest (
> >> >ID int(11) NOT NULL AUTO_INCREMENT,
&g
> "Dan Muey" <[EMAIL PROTECTED]> wrote:
> >
> > I have a table that I create with=20
> >
> > CREATE TABLE SuperTest (
> >ID int(11) NOT NULL AUTO_INCREMENT,
> >Name varchar(64) NOT NULL,
> >Domain varchar(6
Hello group,
I have a table that I create with
CREATE TABLE SuperTest (
ID int(11) NOT NULL AUTO_INCREMENT,
Name varchar(64) NOT NULL,
Domain varchar(64) NOT NULL,
PRIMARY KEY(ID)
);
I use that same thing to create a the same table on two servers.
On one server
> Hi,
Howdy
>
> I know that Mysql handles large database very well, but there
> is a project
> that requires more than 2000 small databases(about 20 talbes
> with a few
> rows) to be created within a Mysql server. Could somebody
> tell me does it
> make sense?
Err.. Sure it makes sense I
> All,
>
Howdy,
> I'm building a member signup form. Fields that contain more
> than one word are being truncated when being inserted into
> the MySQL table.
>
> I'm using this code that I got from one of my PHP books.
>
> $as_addr1 = addslashes($_POST['addr1']);$tr_addr1 = trim($as_addr1)
I'm writing a function for Perl module I'm writing that will allow you to do
$query = "SELECT".DBIallexcept($dbh,'fred','wilma')."FROM monkey";
If that will help. Let em know and I'll notify you when it's done.
Thanks
Dan
>>
> As Victoria says, you can't. However I agree that this syntax
>
> I have tried to remove myself from this list, but the unsubscribe
> function does not function. How does one get off of this list?
At the risk of sounding condescending
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
Is at the bottom of every message.
Also if that doesn'
> Dear Ladies and Sirs,
>
> can anyone give me a hint please, if it is possible toimport
> data data from a zipped File, without unzipping it before.
> I'm using MySQL 3.23 on a LINUX System. I guess it is
> possible using a 'named pipe' and 'funzip' , but I don't lnow how.
I've used Perl and
I was wondering if anybody wth expereince with other
tables types than MyIsam would be able to fill in a few blanks for me:
I'm trying to find what file extentions are associated with what table types. And
which file types are associated with the Field's listed below of a SHOW TABLE STATUS.
Or
> Hello Dan,
>
> Probably the reason that no-one has replied to you is that
> on-one feels that they have anything helpful to add to what
> you already know. A quick check on my system shows that the
> data and index sizes reported by SHOW TABLE STATUS are the
> same as the byte sizes of the M
Excellent Terry Thanks I'll into that a little more.
Basically I'm trying to make the most efficient function I can
That will return the size of a table and the size of a database,
so I can put it in aPelr module and make it avaialable to all.
Thanks
Dan
> -Original Message-
> From: T
nd 'Index_length' are in bytes and
> added together would make the disk size that that table
> is using up?
>
> Thanks a bunch
>
> Dan
>
> > -Original Message-
> > From: Dan Muey
> > Sent: Wednesday, July 30, 2003 4:24 PM
> >
Ok at least could someone tell me if the SHOW TABLE STATUS
fields 'Data_length' and 'Index_length' are in bytes and
added together would make the disk size that that table
is using up?
Thanks a bunch
Dan
> -Original Message-
> From: Dan Muey
> Sent: Wed
Is this even possible with mysql then?
> Howdy List!
> A couple questions about finding the disk space used by a
> table/database:
>
> 1) First how can I get the size a table is taking up on disk?
> Is it the 'Data_length' field in: SHOW TABLE STATUS
> FROM db_name LIKE 'wild';??
>
Howdy List!
A couple questions about finding the disk space used by a table/database:
1) First how can I get the size a table is taking up on disk?
Is it the 'Data_length' field in: SHOW TABLE STATUS FROM db_name LIKE 'wild';??
If so how can I do a query like the one above
> Has anyone written a perl script to get records from another
> database and write it to a file on mysql's LOAD DATA INFILE
> format? I just need some pointers in perl so a LOAD DATA
> INFILE will be read correctly.
You might want to check out Perl's DBI module at search.cpan.org
I use that a
23 matches
Mail list logo