e if you had started mysqld with that parameter. To start with a
back_log of 200, you must do:
c:\>mysqld -O back_log 200
when mysqld is not running, then run mysqladmin variables to see if it
was updated.
--
Chris Bolt
[
> Is there a list off MySQL error-codes avalible?
> Something like Oracle's oerr. program?
perror
> We are having trouble with one of our MySQL databases. The error is:
>
> "Got error 124 from table handler."
chris@entropy:~$ perror 124
Error code 124: Wrong medium type
124 = Wrong index g
> Of course, the SAME spam we saw before appears again. No surprise.
> Does anyone still believe this will go away by itself? It won't -
> it will only get worse - unless the list administrators actually
> *do* something about it! The filters DO NOT WORK.
Is there any reason why the list can't ju
> when as root I give command
> /usr/bin/safe_mysqld &
> It gives me following messages:
> Starting mysqld daemon with databases from
> /var/lib/mysql and on the next line it says
> mysqld ended.
What does /var/lib/mysql/`hostname`.err say?
--
> Is it possible to update a field with the result of a select.
> For example:
Try:
SELECT @newbalance := ordr_order.total_cost - sum(ordr_payment.amount) FROM
ordr_order LEFT JOIN ordr_payment on ordr_payment.ordr_order_id =
ordr_order.id WHERE ordr_order.id = 1;
UPDATE ordr_order SET balance =
> #2 All I have read on the web/books suggests that this is what to do
> $result = mysql_query ("SELECT title, description, url, author,
> date_format(datefield, %M %D %Y') FROM documents");
>
> This just leaves out all dates.
You may want to try:
$result = mysql_query("SELECT title, descrip
> Here's the simplified query:
>
> SELECT members.name, group.id, group.name
> FROM members
> LEFT JOIN members AS group
> ON group.id = members.group_id
> WHERE members.id = 6
>
>
> And here's the error I get:
>
> You have an error in your SQL syntax near 'group ON group.id =
> me
> 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.
UPDATE table SET row = row + 250 WHERE id = #;
---
> > regarding mysql_pconnect() we haven't tried that, but the nature of
> > the site suggests it would need like 500 apache deamons connected
> > all the time. And that's a lot of sort buffers and stuff beeing
> > allocated for each one of those ?
Not if you disable keepalive requests, which I do
> Our brand new, fresh install of 3.23.46 won't let us set the
> password for the root user because one seems to already be set.
> Even after wiping the ...mysql/data/mysql directory clean and
> rerunning mysql_install_db, we still get an "Enter password:"
> prompt when attempting to set the root
> It puts the messages in a tree and makes viewing pertinent threads
> a breeze,
My mail client puts messages in a tree and makes viewing pertinent threads a
breeze. And even with the archives:
http://marc.theaimsgroup.com/?t=10043869449&w=2&r=1
Doesn't look hard to me...
database,sql,quer
> > Only with ISAM tables which reuse deleted auto_increment numbers. MyISAM
> > tables will give you "Duplicate entry" errors if you hit the maximum.
>
> I hadn't realized this and tested it out in MySQL 3.23.43, but in my tests
> ISAM tables also returned a "Duplicate entry" error when I hit
> t
> quickie: can auto_increment wrap?
Only with ISAM tables which reuse deleted auto_increment numbers. MyISAM
tables will give you "Duplicate entry" errors if you hit the maximum.
-
Before posting, please check:
http://www.m
> I am a newbie at this and I cannot find the damn answer to it! I want
> to display the table in an html format with PHP but I cannot get it to
> work! With MS SQL Server it was sooo easy! With PHP and mySQL it's a
> pain in the butt! I cannot find any documentation on this and I order 3
> bo
> I'm using 3.22.27 and am getting an error when I submit queries.
>
> I do a select * from table where...
>
> And it gives me:
>
> ERROR 1030: Got error 127 from table handler
chris@entropy:~$ perror 127
Error code 127: Unknown error 127
127 = Record-file is crashed
Run isamchk -r on the ta
> Is there a way to raise this limit? We have some tables with columns that
> are VARCHAR(200), and need to make a primary key based on combinations of
> these columns (in some cases, upto 4 columns), and MySQL complains for all
> of these table definitions that "Specified key was too long. Max ke
> I have been trying to get mysqld to run under 2 ip addresses
> (localhost and an external ip address). Using the bind-address
> option twice doesnt seem to work, nor does lisiting 2 ip addresses
> in the option. I hope mysqld has this functionality to be able to
> run under certain ip addre
> I would like to find out what record in the table has
> the largest amount of characters. This way I could possibly
> decrease the varchar size (currently 100) to speed up the
> queries.
>
> My table is as below.
> CREATE TABLE competitor (
> CompetitorsName varchar(35) not null,
>
> Have you also increased your master maxfiles as well? If not, you're not
> getting the number of file handles you expect you are. I'd also consider
> upgrading to 4.3, as it's much faster than 3.x.
>
> Try this --
> sysctl -w kern.maxfiles=16424
kern.maxfiles is already the same as .maxfiles
Right now MySQL is getting really backlogged but I have no idea why. There
are 169 concurrently running queries, and 153 of them are in show the status
as "Opening tables". A processlist looks something like this (formatted by
Status, Seconds query has been running, and query):
Opening tables
> I am currently using Slackware 8 (linux) and I have some problems. There
> is mysql package in the slackware installation, which I installed it but
> never manage to run it successfully. Everytime I type the following
> > safe_mysqld
> and I get the following message:
> > Starting mysqld da
> Im managing to do this, but I can see that the method im using is
> not as efficient as it could be. What I want to do is this
> Make a query which will grab the record in a table that has the
> highest ID number. The ID field is auto incremental so what its
> saying is that the record with
> Thankx for reply.
> But if I use Table Repair it says : The handler for te table
> doesn't support Check/Repair.
What does SHOW TABLE STATUS LIKE 'tablename'; say for the Type column?
-
Before posting, please check:
http:
> Hello,
>
> I was working with Mysql an nerver had any problem, the suddenly from one
> moment to the other, some tables didn't work correctly any more.
> Any select
> command on them returns me :
> 1030: Got error 127 from table handler.
> But if I do a select command on a other table with a j
> I need to search a mysql database using wildcards. I know about the * and
> the _ wildcards (any number of any character and 1 character of any kind,
> respectively) but I need to match any number, any letter and thing like
> that.
>
> An SQL book claimed it could be done using brackets and rang
> SQL question which I am new to.
> How would I count the number of times a specific entry is in field. For
> instance I have a table that has the following two fields
> numberhostname
> 1 10.1.1.1
> 2 10.1.1.2
> 3 10.1.1.3
> 4
> > I am looking build my own E-mail Server for my Domain and would like
> > some pointers
> >
> > Is there an E-mail Server that uses MySQL
>
> Exim, Postfix, and Sendmail can all use MySQL to varying degrees.
> There are probably others.
qmail; http://cr.yp.to/qmail.html, http://www.lifewithq
> A quick question: How come the mailing list software
> doesn't add a reply-to header? Is this intentional to
> keep replies off the mysql list, and if so why?
http://www.unicom.com/pw/reply-to-harmful.html
-
Before posting, pl
> now i changed the root password just fine
> but now i have to enter it every time i run mysqladmin
> even "mysqladmin version" reqires a "-p"
>
> tell me there's a simpler way
http://www.mysql.com/doc/C/o/Connecting.html
* You can specify connection parameters in the [client] section of th
> I'am having this error code (Error 12 from table handler) when i am trying
> to create an index on a table that has about 20 records (it's
> not a big table)...
> What does this error code means?.
chris@illusion:~$ perror 12
Error code 12: Cannot allocate memory
chris@illusion:~$
-
> I want to create a table with two Primary Keys. The first key is
> a category
> field, and the second is auto-incremented. Example: Key
> 1=Chapter name, Key
> 2 =section number. For example, (Chapter1, 1) (Chapter1, 2) (Chapter1, 3)
> then with a new Cheaper, I want to restart the auto-incre
> is it generally recommended / a good idea to have more than one PRI index
> in the same table? i've never seen that before until today while trying
> to track down bugs in someone else's system and noticed a table with 2 PRI
> indexes. will this cause any problems?
It shouldn't cause any prob
> Go error 127 from table handler.. fixed itself in about 10 minutes..
> don't know what this is or why it happened.. anyone know?
>
> It happened while doing an update SQL command to a table.
> I'm not even sure what it means.. can't find any error codes.
Try running perror 127
---
> And is there some way to download the previous posts to this list? I
> found one list admin function that will download up to 100 posts
> concatenated into one email, but I'd like to be able to d/l them
> individually, with their own subject line and threading info. I just
> think it would be
> Is there any way -- using either MySQL directly, or (ideally)
> using the DBI perl module -- to get a list of fields from a
> (possibly empty) table? (If the table is nonempty, you can
> just use a perl function to get the first record, and then
> apply keys() to the returned reference to get
> How is that possible? Even if you do know someone's scrambled password,
> when you connect to the MySQL server pretending to be that user, it will
> ask you for their non-scrambled password. After you type it in,
> the server will scramble it and check that the scrambled value matches
> the sc
> I'm still testing out MySQL and I'm trying to find the my.cnf
> file referred to at
> http://www.mysql.com/doc/O/p/Option_files.html
...
> but none of these files seem to exist on my machine.
...
> MySQL came pre-installed on that machine. Is it possible (or, indeed,
> normal) that the
> update cdrequest set albumfill = "hot shots II", releasedatefill
> = 20010708 where requstID = 2;
>
> i get:
> You have an error in your SQL syntax near '\"hot shots II\",
> releasedatefill = 20010708 where requstID = 2' at line 1
> I can't see any reason for the error.
Your web based inte
> is there any way turn the following query to all ands instead of using an
> or?
>
> select f1,f2,f3 from table1 where (f1 ='monday' or f2 ='monday') and
> f3='34';
SELECT f1,f2,f3 FROM table1 WHERE 'monday' IN (f1, f2) AND f3 = '34';
--
> I am not sure if this has been addressed before, I think it would
> be neat if the list admin could put a [mysql] in the subject line
> for messages. I get a lot of email and it would help having that
> in the subject line. it would also help me in filtering my mail.
> Please let me know your c
> i have a problem in query. My field type is integer.
> The table is empty and i want to select max number from the
> field but it display error message.Then i try to change the type
> to char ,it's can but,
> the max is until 9 only.is there anyone can help me.
What query? What table? What er
> Lets say i have 10.000 rows in a table and im searching for only
> one record(one row).
>
> Which one is faster:
> SELECT ... LIMIT 1
> or just
> SELECT ..
The former, since MySQL stops after finding the first row. In the second
query, MySQL prepares the entire result set even if you on
> Example I have a file name stored in database as: john's - song.mp3
>
> When I click on the link to the song in a web browser I get file not
> found.
http://www.php.net/rawurlencode
-
Before posting, please check:
http:/
> i have 2 mysql servers, i need to run a query that joins two tables
> from two databases on the two servers, how can i do this?
You can't.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
h
> I need to build a search utility which can query records based
> on multiple text parameter,
> my table will have about 10 fields and users can search on
> 3-5 parameters in one query. is there any way to achieve this
> other than doing a full table scan.
http://www.mysql.com/doc/F/u/Fullt
> I am currently trying to examine the benefits of continuing to
> use MySQL over Oracle. I need to know what MySQL's features are
> vs. those of Oracle.
http://www.mysql.com/information/crash-me.php
> Also I am looking for performance data.
Oracle prohibits benchmarks, so good luck finding the
>>> Database error: Invalid SQL: select id, subid from policy where
>>> id='2' and subid='0'
>>> MySQL Error: 1054 (Unknown column 'id' in 'field list')
>>> Session halted.
>
> the output look like this..
> mysql> desc policy;
> +++--+-+-+---+
> | Field
> SELECT * FROM listaemail WHERE id LIKE "%%" OR nome LIKE "%%" OR empresa
> LIKE "%%" OR email LIKE "%%" OR ativo LIKE "%%" ORDER BY nome;
>
> Time: 11 Lock_time: 0 Rows_sent: 30567 Rows_examined: 30568
>
> before anyone jumps out and points it out, it is far
> from being optimized. it should (an
> Hi,
>
> I have looked through the documentation (http://www.mysql.com/docs)
> and the mailing list archives
> (http://www.geocrawler.com/lists/3/Databases/8/0/)
> and find no mention of a feature that I was hoping was available:
>
> * text or varchar columns that are automatically compressed/u
> hi all..
>
> this error came out after i make backup for my database using mysqldump
> what this error say is wrong... maybe my database is corrupt or
> crash or something like that.. any command can fix this error..?.
> any idea what i should do.
Please paste the output of typing "DESCRIBE
> $sql4 = "SELECT hits.hit_id as pixels from hits
> WHERE hit_id=LAST_INSERT_ID();";
>
> $result = mysql_query ($sql4, $connection)
> or die("error #" . mysql_errno() . ": " . mysql_error());
> $row = mysql_fetch_object($result);
> $pixels = number_format($row->pixels);
>
> It's staggering the dif
> mysql> select vend_city+', '+vend_state+' '+vend_zip
> -> from Vendors
> -> order by vend_name
> -> ;
...
> 4 rows in set (0.01 sec)
>
> How do I do this in MySQL?
SELECT CONCAT(vend_city, ', ', vend_state, ' ', vend_zip) FROM Vendors ORDER
BY vend_name;
--
> C:\>mysql grant all on *.* to administrator@sara identified by "delboy"
Try this:
C:\>mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 463668 to server version: 3.23.39-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> grant a
> Hello,
>
> I am still a beginner, but I am trying to learn MySQL. If you have a
> date field, and you are using the date field in your where clause, I
> understand how to use :
> WHERE date="-mm-dd"; I am trying to find out if there is anyway
> to use the wildcard character % in d
Am I the only one getting these? Someone really needs to fix their mail
server...
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 13, 2001 4:10 AM
To: [EMAIL PROTECTED]
Subject: No valid command found
Your message does not contain a valid command
> 3. Is this a MySQL feature / bug or do other DBs support this?
It doesn't work in Postgres.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list arch
> > He wants to know the maximum, like on a search for mysql at
> > google it says "Results 1 - 10 of about 2,580,000." He wants
> > to know that 2,580,000 number without doing another query.
> > I don't think that's possible.
>
> Of course it is. That's what I do all the time. That's what I was
>
What error did you get? Did you try using NULL for the id, or leaving the
auto_increment column out of the insert (insert into table (PartNumber, ...,
StatusQtyWorked) values (...))?
> Hello,
> When I submit data it will not submit data into the
> database unless I put some kind of number in the
http://marc.theaimsgroup.com/?l=mysql&m=99257445520048&w=2 may help
> OK, another one here...
>
> On the very large table (at least 5 million rows) I need to index
> several columns. The mysqladmin -i60 processlist
>
> lists the state of the query as
>
> Repair with keycache
>
> for a ver
> umm when i declare a unique constraint on 2 fields in a table like so
>
> unique (col1,col2),
>
> if i insert data into the table will it check them individually or as a
> composite?
>
> for example if i inserted the values
> col1 | col2
>1, A
>1, B
>2, B
>
> I create a table, one field is integer type.
> I don't know why the following statements work :
>
> select * from table1 where field1 = 3;
> select * from table1 where field1 = '3';
In the second case, MySQL automatically casts '3' to 3.
--
> Group;
>
> There is something missing in my understanding of the php mysql_connect
> statement because I am getting a parse error as follows:
>
> http://cxkop.com/Jobs/job_list.php
> Parse error: parse error in
> /home/virtual/cxkop1365/home/httpd/html/Jobs/job_list.php on line 31
This is a php
> Just wondering how many accesses can MYSQL handle... let's say per hour.
> I have about 500 accesses per hour, 8 clicks per second... does anyone
> know about this issue? thanks
It really depends on what kind of queries you're running, your hardware,
your configuration, your operating system, e
He wants to know the maximum, like on a search for mysql at google it says
"Results 1 - 10 of about 2,580,000." He wants to know that 2,580,000 number
without doing another query. I don't think that's possible.
> I'm not sure if I understand your problem. You should get exactly
> $end results if
> Hi,
>
> I want to compress my tables but I gets an error:
>
> C:\mysql-data\dtim9t>myisampack wi_abbreviation.MYI
> Compressing wi_abbreviation.MYD: (7221 records)
> - Calculating statistics
> - Compressing file
> myisampack: Error on delete of 'wi_abbreviation.MYD' (Errcode: 13)
> Aborting: wi_
> Is it possible to join two columns from different databases
Yes.
> located on differents hosts?
No. Why do you want to do this?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lis
> sorry im a mysql newbie...how do you bind mysql to two particular ip
> addresses? i have it bound to my loopback but would like to bind it a
> private ip but it doesn't seem to like the bind-address directive
> more than once.
Run two separate mysql daemons with a different --bind-address para
> We do a few large daily and monthly downloads from an Oracle database
> server. Is there a way to exclude these specific queries from the
> update/binary log??
If the queries only affect one table or database, use the replication ignore
options listed here: http://www.mysql.com/doc/R/e/Replicat
> Done, an email is now sent after an order is submitted. This is what it
> I have found a large number of files which have names like this
> www-bin.040
> www-bin.041
> www-bin.042
> www-bin.043
> www-bin.044
>
> which are using up huge amounts of disk space on my server.
>
>
mysqldump databasename | gzip > databasename.sql.gz
transfer that file to the other server
mysqladmin create databasename
zcat databasename.sql.gz | mysql databasename
> Hi
>
> Is it possible to import a complete database from a server to another
> one?
>
> Thanks
>
> Eugénio
--
No. To rename a database, rename the directory in mysql's data dir. There is
no SQL command to rename a database.
> [mysql]
>
> is this how to change the the name of an existing populated db?
>
>
> RENAME DATABASE old_name TO new_name;
>
> TR
Why does it matter? They can't access them, so what harm is there?
> I am sure that it has been asked before. I am running a
> hosting company
> and I am running mysql on a win2k server.
> We don't want any customer to see other db's of any other customer, we
> just want them to see their
> > Hi,
> >
> > I have mysql on NT4 (soon to be win2000). one question is that the
> > database files all reside under drive c. NT does not have symbolic
> > link
>
> I seem to recall Microsoft making a big deal out of the fact that they
> "invented" symbolic links and added them to Win2000. A
Try looking in mysql\data\mysql.err or running mysqld --standalone, it may
provide more information.
> Hello everyone,
> I have mysql-3.23.39 installed on a Win2k Pro box (not sure why!). It had
> been running just fine, then all of a sudden stopped working.
> When I try a
> 'NET START mysql', I
MySQL doesn't support foreign keys. Did you bother checking the manual?
http://www.mysql.com/doc/M/i/Missing_Foreign_Keys.html
> Hello
>
> Does mysql support creating and dropping of foreign key constraints?
> i tried it.While creating foreign key constraints it doesn't dive
> any error
> but wh
> Hi!
>
> Does anybody know how do i change the 'root' password for mysql server?
>
> I installation guide they say that it's done by typing
> '/usr/local/bin/mysqladmin -u root -p password new-password', but how
> would i know the old passsword?
> Am i mising anything?
Leave out -p
-
DELETE FROM mbtable WHERE timecolumn < DATE_SUB(NOW(), INTERVAL 3 MONTH);
> Hello,
>
> I've a messageboard. Now, I want to delete all messages older than 3
> months. Can I use a MySQL query to delete all messages or do I have to use
> mktime()?
--
Your question has been answered already.
http://marc.theaimsgroup.com/?l=mysql&m=99348999221821&w=2
> Hi All,
>
> I've been reading up on how to do joins on the mysql site.
>
> Is there not an inverse function for DISTINCT, so that I can pull out
> duplicate data as opposed to DISTINCT data...o
> This is how I'd like the query to work:
> insert into host (host_id, host_IP) values ((select from mail
> mail_id where
> mail_addr = "[EMAIL PROTECTED]"), '127.0.0.1')
Try:
insert into host (host_id, host_IP) select mail_id, '127.0.0.1' from mail
where mail_addr = '[EMAIL PROTECTED]';
-
http://www.mysql.com/doc/
> HI Everyone
>
> I am looking for a summary/examples of the syntaxes and operators
> one may use
> in standard sql statements
>
>
> For example
> select name from epm_tble where name like 'abc%'
> select x, count(*) from table_where_x_is_in group by x having count(*)>
> Hi,
>
> How to bind mysql to specific address if I am using my.cnf file.
>
> etc.
> [mysqld]
> --bind-address=xxx.xxx.xxx.xxx
>
> Is the above syntax correct ??
Close.
[mysqld]
bind-address=xxx.xxx.xxx.xxx
-
Before p
> Hi,
>
> I am not able to connect mysql server through other
> machine in a
> network. I have already assign the user using the command of
> "Grant all on
> *.* to user@ipaddress identified by "password". Then, try to connect using
> "mysql -u user@ipaddress -h firstserver -ppassword
ALTER TABLE tblname ADD UNIQUE (column1, column2);
The index will automatically be used if you use it in your WHERE clause in
that order. If you want to do fulltext searching on those columns, repeat
the query with FULLTEXT in place of UNIQUE.
> Hello,
>
> I'm trying to create a table with colum
USA: http://mysql.he.net/
UK: http://mysql.omnipotent.net/
> I have been trying to access www.mysql.com but can not seem to access it.
> Does anyone know a mirror site I could go to to download mysql for Windows
> 2000?
>
> Thank you!
---
> As a long time DB2.. Sybase.. & Postgresql user upon turning to MySQL
> I find only some functionalities not intuitive.
>
> 1. What command syntax to use and connect to a database on another
> host.
You've got to be kidding me, it's exactly the same as Postgresql:
chris@phantasm:~$ mysql --hel
Try
net start mysql
at a command prompt
> Hi Team,
>
> Pls help, I'm new to mysql.
>
> I got the latest ver installed on NT2000 workstation. Upon I
> tried the activate the daemon, under c:\mysql\bin\mysqld,
> it won't work. Any advise.
>
> Thanks & Regards
> KA
--
Yes, just stop the mysql service before you begin installation by running
something like
net stop mysql
from a command prompt.
> Hi everyone,
>
> I'm kinda new with MySQL and I have a question about upgrading MySQL to a
> newer version on Windows 2000 OS. Is there any special command that I
> s
> Just a couple of questions regarding indexes...
>
> Can I have multiple indexes on the same column?
Yes, but it's kind of pointless.
> Will this decrease performance when inserting?
Yes.
> Can you create and remove indexes after the creation of the table?
Yes.
---
Download and install
http://www.perl.com/CPAN-local/authors/id/J/JW/JWIED/DBD-mysql-2.0901.tar.gz
> Hi,
>
> I am a newbie and hope someone can she light on why I can't get the
> DBD::mysql connection working in my perl script. The script is a test one
> and very simple.
>
> I have the mysql daem
Use http://www.mysql.com/doc/R/e/Resetting_permissions.html to reset your
password.
> could someone tell me how to make a clean sweep of MySQL from my
> system so i can start over?
> (i need to toss phpMyAdmin temporarily too
>
> i get asked for a password at every bend and none of the ones i use
With MySQL 3.23's MyISAM tables, yes, since they are platform independent.
> Hi,
>
> Do someone maybe know, if it is possible to transfer a
> mysql database?
> Is it enough, that I copy the
> /mysql/data/$databasename to another computer to have
> there the same database with the same tables an
http://www.mysql.com/doc/R/E/RENAME_TABLE.html says:
As long as two databases are on the same disk you can also rename from one
database to another:
RENAME TABLE current_database.table_name TO other_database.table_name;
And as the user comments say, you can use ALTER TABLE with 3.22.
Copying c
What are the types of the columns?
> Hi all,
> ... running this query
>
> alter table item_dettagli
> add fulltext(categoria_prezzo,settore,movimento,soggetto,lingua)
>
> I get this error:
>
> 1005 - Can't create table '.\pickwick\#sql-3d0_2.frm' (errno: 140)
> Query:
> alter tabl
The default max_allowed_packet is 1 meg
http://www.mysql.com/doc/P/a/Packet_too_large.html
> hi
>
> Can anyone please help with regards to long blob data insert.
> I have a data which more than 1mb which MySQL long blob field
> refuse to insert.
> However if my data is less than 1mb there if n
http://www.mysql.com/doc/R/e/Replication.html
> Hi all,
>
> I'm new to this list, fairly new to PHP and mySQL and I have a question
> about syncing two databases. I search all over the web for this,
> including a
> win32 version of rsync, but that's not suitable in my case, so
> here it goes:
http://marc.theaimsgroup.com/?l=mysql&r=1&w=2
> Is there an archive to this list?
>
> My MS Access ODBC is not sending the user name to MySQL, and I don't
> doubt that it is a known problem.
-
Before posting, please check:
> I have downloaded the mySql distribution as well as
> 2 different versions of gnu tar that available at the site.
>
> gtar-solaris-4.1.4-sparc.gz and gtar-sparc.gz
>
> The reason I downloaded 2 different versions of the gnu tar
> is that I can't get anyone of these to deflate using gzip.
>
> I h
> Hi there,
>
> I'm using select queries like
>
> SELECT * FROM table_name WHERE col_name LIKE '%some_word%'
>
> to find rows that have col_name match to some_word. But I would also like
> to find the number of word matches for each row so that I can order these
> rows according to their relevanc
> thank you.
> that's sort of what i thought.
>
> now for the silly question:
> i know how to do it with 'monitor' (CLI), but where/how do you
> "import" using phpMyAdmin, please? (this i'd love to know :) i looked
> through the manual but didn't see anything for "import" db.
Click a database on
> Fatal error: Call to undefined function: dayname() in
> /home/ccrb/ccrb-www/index.html on line 8
>
> This indicates that I'm missing most all of the functions. Is there a
> standard include that I need, or is my php installation not complete?
>
> Here is the line of code in question:
>
>
1 - 100 of 164 matches
Mail list logo