RE: Uploading database content with PHPMyAdmin
> 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 the form. I wait a few minutes and I then get an error message > saying I am using the wrong syntax. How do I instruct it to accept a > mysqldump file? If it doesn't accept dumped files, then what > do I have > to do to get the data up to a remote server? > There's an "execute sql in a file" somewhere near where you can type a query in. This link may help: http://sourceforge.net/forum/forum.php?forum_id=72909 > I have searched for PHPmyAdmin but didn't get any reasonable results. > So I don't even know what I am looking for. > > Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Is there any documentation of Best Practices/Troubleshooting Guides for Administering MySQL
> Thanks, No problem, but please post to the list and not just me so we can all learn and share. Also top posting is bad form, just FYI. > > I have been perusing the web site, but the manuals don't > always give reasons WHY you would run something. For example http://www.mysql.com/doc/en/FLUSH.html the why/what/who: You should use the FLUSH command if you want to clear some of the internal caches MySQL uses. To execute FLUSH, you must have the RELOAD privilege. > the flush-tables command. Why would you run it and what does > it do? There are several references to this command but I man mysqladmin summed it up for me niceley > can't seem to find exactly what it does. Can I do it any > time, is it non-destructive etc. If the site and man don't give you the kind of answer you seek then post the specific 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/Troubleshooting Guides for Administering MySQL > > > > 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 problems. > > > > The staff is all very technical - Senior level Oracle DBAs > - I'm going > > to have to drag them kicking and screaming into the MySQL world :-) > > > > Thanks in advance. I'm having fun with this tool, I'm > looking forward > > to see how it does in production. > > It will do awesome, it always has for me anyway! > I'd say the best general guide is the mysql.com website, very > informtive and intuitive. > > HTH > > DMuey > > > > Evelyn -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
OT: Bash script to MySql
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 though!) So I wanted to share with him, in a friendly nature of course ;p, this: If you can't read the code, run it through here: http://perltidy.sourceforge.net/ Now you don't have any excuses! :) Ok no more OT posts! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Is there any documentation of Best Practices/Troubleshooting Guides for Administering MySQL
> 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 problems. > > The staff is all very technical - Senior level Oracle DBAs - > I'm going to have to drag them kicking and screaming into the > MySQL world :-) > > Thanks in advance. I'm having fun with this tool, I'm > looking forward to see how it does in production. It will do awesome, it always has for me anyway! I'd say the best general guide is the mysql.com website, very informtive and intuitive. HTH DMuey > Evelyn > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Bash script to MySql
> 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 support very mature the entire language is! *AND* you don't have to mess with PHP Which, as an administrator of lots of servers over the years, is only seconded in horribleness of headaches by Microsoft stuff. Didn't want to start flames going just wanted to pint out a better alternative. > > -- > Russell. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Simple Binary Download Difference question
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 difference? TIA Dan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql_install_db and error 22
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 running mysql_install_db following the same instructions mentioned at the link above. It does create the 'mysql' and 'test' directories in the data directory but no files in either. (Although isn't 'test' empty at the start anyway?) I feel like if I could get the mysq/ db tables set up I'd be in business. So any ideas what I can do to get past this? Is it possible to manually create the files necessary or is it kosher to just copy them from another server(doubtful) (linux)? Any help would be greatly appreciated! TIA Dan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: AUTO_INCREMENT Starting over
> "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, > >> >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 (mysql Ver 11.16 Distrib 3.23.49, for=20 > >> > portbld-freebsd4.6 =3D > >> > (i386)) > >> > If I add, say five records I get ID to be 1,2,3,4,5. > >> > Then I delete ID 5 and insert a new record and it's id is=20 > >> 6. So now I =3D > >> > have 1,2,3,4,6. > >> > That's what I want it to do. > >> > However on the other server (mysql version ???) if I have=20 > >> 1,2,3,4,5, =3D > >> > delete ID 5=3D20 > >> > and insert a new one it makes the new one ID 5. I suppose=20 > >> because it's =3D > >> > the next number. > >> >=20 > >> > I'm not really even sure what to call it besides 'non reusable > >> >=3D=20 auto_increment'. =20 > >> > I can't seem to find anything on mysql.com about what > settings,=20 > >> > version, =3D etc cause it to work either way. > >>=20 > >> It depends on table types. AUTO_INCREMENT values are > reused=20 for > >>BDB and ISAM tables and not reused for MyISAM and InnoDB tables. > > > > Oh cool! > > So if I want to reuse them and know 100% they will be > reused I=20 need > > to specify the type as BDB or ISAM. And if I want to not reuse them > > and know 100% for sure they won't=20 be reused I need to dpescify > > MyISAM or InnoDB. > > Each of table type has it's own advantages and restrictions. > They are different not only in usage of AUTO_INCREMENT value. > Read more about each table type before choosing table type: > http://www.mysql.com/doc/en/Table_types.html Thanks, I sure will. I appreciate your time! Dan > > > > That's were my problem lay I believe, I never specified the > table=20 > > type and just let it happen as it felt like. Lesson > learned! Thanks a > > million! > > > > > > -- > For technical support contracts, goto > https://order.mysql.com/?ref=ensita > This email is sponsored > by Ensita.net http://www.ensita.net/ >__ ___ ___ __ > / |/ /_ __/ __/ __ \/ /Egor Egorov > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ><___/ www.mysql.com > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?> [EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: AUTO_INCREMENT Starting over
> "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(64) NOT NULL, > >PRIMARY KEY(ID) > > ); > > > > I use that same thing to create a the same table on two servers. > > > > On one server (mysql Ver 11.16 Distrib 3.23.49, for > > portbld-freebsd4.6 = > > (i386)) > > If I add, say five records I get ID to be 1,2,3,4,5. > > Then I delete ID 5 and insert a new record and it's id is > 6. So now I = > > have 1,2,3,4,6. > > That's what I want it to do. > > However on the other server (mysql version ???) if I have > 1,2,3,4,5, = > > delete ID 5=20 > > and insert a new one it makes the new one ID 5. I suppose > because it's = > > the next number. > > > > I'm not really even sure what to call it besides 'non reusable = > > auto_increment'. > > > > I can't seem to find anything on mysql.com about what settings, > > version, = etc cause it to work either way. > > It depends on table types. AUTO_INCREMENT values are reused > for BDB and ISAM tables and not reused for MyISAM and InnoDB tables. Oh cool! So if I want to reuse them and know 100% they will be reused I need to specify the type as BDB or ISAM. And if I want to not reuse them and know 100% for sure they won't be reused I need to dpescify MyISAM or InnoDB. That's were my problem lay I believe, I never specified the table type and just let it happen as it felt like. Lesson learned! Thanks a million! DMuey > > > > Any insight would be greatly appreciated as in some situations I > > really = need it to be one way or the other consistently across > > servers. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
AUTO_INCREMENT Starting over
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 (mysql Ver 11.16 Distrib 3.23.49, for portbld-freebsd4.6 (i386)) If I add, say five records I get ID to be 1,2,3,4,5. Then I delete ID 5 and insert a new record and it's id is 6. So now I have 1,2,3,4,6. That's what I want it to do. However on the other server (mysql version ???) if I have 1,2,3,4,5, delete ID 5 and insert a new one it makes the new one ID 5. I suppose because it's the next number. I'm not really even sure what to call it besides 'non reusable auto_increment'. I can't seem to find anything on mysql.com about what settings, version, etc cause it to work either way. Any insight would be greatly appreciated as in some situations I really need it to be one way or the other consistently across servers. TIA DMuey -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: multiple databases creation
> 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 guess although we have no idea what you're trying for. Perhaps instead of: Business1_db table1 table2 table3 Business2_db table1 table2 table3 DO this: BusinessDB b1table1 b1table2 b1table3 b2table1 b2table2 b2table3 HTH DMuey > Thanks for your consideration. > likai > > _ > Protect your PC - get McAfee.com VirusScan Online > http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?> [EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Form values are truncated
> 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 think trim is trimming off the stuff after the first whitespace? What is the trim function supposed to do? Mysql isn't doing it your PHP is. Use Perl and I bet it starts working :) ok, or you could fix or replace the trim function with one that does not remove that data. HTH DMuey > > So, if I post "1122 Boogie St." it gets inserted as "1122". > If I remove the "addslashes" portion, only using trim, I get > the same result. > > Here's the query: > $query = "INSERT INTO subscribers > (email,password,fName,lName,addr1) > VALUES > ('$tr_email','$tr_pass','$tr_fName','$tr_lName','$tr_addr1'"; > > echo $query; > > Here's the echo: > INSERT INTO subscribers (email,password,fName,lName,addr1) > VALUES('[EMAIL PROTECTED]','','Jim','Johnson','78797 State') > > I have other fields in the table that are doing the same > thing. All fields are varchars of varying length. Field > "addr1" is varchar(50). > > Suggestions? > Thanks, > James -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: how to 'tell' the select what to omit
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 > is useless in many real-world situations. You are not the > only one who finds this behaviour annoying. It's about time > someone made SQL a 21st century language... > > > > "Miroslav I." wrote: > > > > Hallo > > > > suppose you have a table with great number of columns (20 > or 30), and > > you would like to specify every one but two or tree columns in a > > SELECT statement. > > > > Is there a way to specify only those two or tree columns > for omission > > (which would be the 'short' way to do the job) instead of > specifying > > every column that needed (which would be the 'long' way to do the > > job). > > > > Example: > > > > The 'TName' table header: > > > > id | name | surname | dateOB | idSCHOOL | idCITY | idSTATE | sex | > > idParent1 | idParent2 | interests | weight | height | age | > auditDate > > | idAudittor | > > > > You need every field except the 'dateOB' and 'idSCHOOL' > > > > Ordinary select wold be: > > > > SELECT > > > id,name,surname,idCITY,idSTATE,sex,idParent1,idParent2,interests,weigh > > t,height,age,auditDate,idAudittor, FROM TName > > > > It is too long expression, > > is there a way to specify only 'dateOB' and 'idSCHOOL' - the two > > column that are unwanted in the result set - in order to make the > > SELECT shorter? The SELECT should return every column but the > > specified ones. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?> [EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: How does one get off of this list
> 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't work take a look at the headers. There should be a bunch of List-*** headers and one will gie you an address to send unsubscribe requests to. HTH Dan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL LOAD zipped DATA from File
> 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 the Archive::Zip module to grab a text file form a zip file and use it to populate a database. I write mine to a temp file but there might be a way to do grab it into a variable and process it straght up instead of wiritng to a file but If it's very big youmay not want to do that. I'd check our search.cpan.org for Archive::Zip and do it in Perl! Check out [EMAIL PROTECTED] HTH DMuey > > Thank you > Klaus -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
TABLE STATUS
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 if those fields otherwise give you the size of the table plus things that are not inluded in that query, like the .frm files. My areas of ignorance is marked with question marks: Thanks Dan +--+ |http://www.mysql.com/doc/en/SHOW_TABLE_STATUS.html| +--+ Field MyIsam Merge ISAM HEAP InnoDB BDB/BerkelyDB -+---+--+--+-+--+---+ Data_length + .MYD + ?? + .ISM + ?? + ?? + ?? + Index_length + .MYI + ?? + .ISD + ?? + ?? + ?? + -+--+ Other files not included in SHOW TABLE STATUS query-+ + .frm + .frm + .frm +.frm?+.frm??+ .frm?? + + + .MRG + + + + + + + + + + + + + + + + + + + + + + + + + + + -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Finding Table and database size
> 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 MYD and MYI files - which is a > clue that they may represent the table sizes in bytes. > Whether this also applies to InnoDB tables, I have no idea. > Excellent > SImply checking the manual page > http://www.mysql.com/doc/en/SHOW_TABLE_STATUS.html will show > that there is no syntax for selecting only a few columns from > the SHOW STATUS. The fact that no-one else has replied > suggests that there is no alternative command. However, > unless your number of tables is prodigious, the extra data > transferred is hardly likely to be prodigious. I figured that, I'll just have to loop around in my function and add it all up. > > If you phrase your question in the style "please tell me > more", then you must accept that silence means that there is > no more to tell. If this list cannot answer your question, > your only alternative is to purchase support from MySQL AB > (always a good idea) , and then enquire of the fount of all > (MySQL) knowledge. > > Alec Right on, Thanks Alec -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Finding Table and database size
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: Terry Riley [mailto:[EMAIL PROTECTED] > Sent: Thursday, July 31, 2003 10:16 AM > To: [EMAIL PROTECTED] > Subject: RE: Finding Table and database size > > > Dan > > What you may be looking for (and I had to hunt around to find > it myself!) > is > > myisamchk -eis table_name > > Hope that helps - just because you don't get an answer > doesn't mean we > don't care - it probably means we don't know. > > Terry > > --Original Message- > > > Ok, if this is the wrong mysql list could someone tell me > > which list would best be able to handle my question if no one > > on this list knows how to get the table and database sizes? > > > > TIA > > > > Dan > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?> [EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Finding Table and database size
Ok, if this is the wrong mysql list could someone tell me which list would best be able to handle my question if no one on this list knows how to get the table and database sizes? TIA Dan > 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: Wednesday, July 30, 2003 4:24 PM > > To: [EMAIL PROTECTED] > > Subject: RE: Finding Table and database size > > > > > > 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';?? > > > If so how can I do a query like the one above > > > and just get Data_length returned? > > > Otherwise what query can I do to find the disk size of a table? > > > > > > 2) Is there a simple query to get the disk size of a database and > > > all of it's tables? Or do I need to do the method I use > in question > > > one on each table in the db and add them up? > > > > > > TIA > > > > > > Dan > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > > http://lists.mysql.com/mysql?> [EMAIL PROTECTED] > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?> [EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Finding Table and database size
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: Wednesday, July 30, 2003 4:24 PM > To: [EMAIL PROTECTED] > Subject: RE: Finding Table and database size > > > 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';?? > > If so how can I do a query like the one above > > and just get Data_length returned? > > Otherwise what query can I do to find the disk size of a table? > > > > 2) Is there a simple query to get the disk size of a database > > and all of it's tables? Or do I need to do the method I use > > in question one on each table in the db and add them up? > > > > TIA > > > > Dan > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?> [EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Finding Table and database size
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';?? > If so how can I do a query like the one above > and just get Data_length returned? > Otherwise what query can I do to find the disk size of a table? > > 2) Is there a simple query to get the disk size of a database > and all of it's tables? Or do I need to do the method I use > in question one on each table in the db and add them up? > > TIA > > Dan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Finding Table and database size
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 and just get Data_length returned? Otherwise what query can I do to find the disk size of a table? 2) Is there a simple query to get the disk size of a database and all of it's tables? Or do I need to do the method I use in question one on each table in the db and add them up? TIA Dan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Perl/mysql question
> 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 all the time to interact with mysql. Simple quick and just as sexxy as mysql itself! HTH DMuey > > For example, a perl script: > Select * from emp from a Progress database > Will write to a text file called emp.txt in the LOAD DATA > INFILE format, Then, I can to a direct LOAD DATA INFILE into > my mysql database. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]