Does mysql have an easy way of backing up a database Basically I have a php page and I would like to be able

CheapWebHosting.co.nz

Web Hosting

I have a problem with MySQL 5026 on a amd64 using more than 4G in the key_buffer It crashes with a signal 11 error

you can do column level permissions

I'm wrong!

:-)

please, for a french guy

!manfr replication

voyez http://dev.mysql.com/doc/refman/5.0/fr/replication.html

hehhe

I always pretend to be swedish, when I'd say 'please, for a german guy' I don't get many positive responses
always choose a country nobody knows or hates!

it is more hard to read french doc really lol
harder*

maybe that book has also been translated

Sweden is good. They say Swedes are so neutral their farts don't smell

I thought swedes are the socialists and swiss are the neutral ones.

nah the Swiss are the bankers

but they are neutral

yeh but that's only their 2nd most important theme

indeed

im getting this error
Call to undefined function mysql_connect() in /var/www/personal/ConnectionFile.php on line 11
does anyone know what that means?

yep

what?

zabi1, you need to install the php mysql module

it means there is no such function as mysql_connect.
you have to enable/install the php mysql hosting module

do you know what that is for ubuntu?

apt-get install php5-mysql

php5-mysql I think

or php4-mysql for good old php 4
time for some wine

thanks

SELECT * FROM categories c JOIN survey_questions sq ON c.category_id=sq.category_id WHERE category_id=4 I cant seem to get my join work, just learning them . . can anyone give me a hand?
hrml I think I would need WHERE c.category_id and sq.category_id but I just dont know where to put the WHERE clause in the join

night all

daf_, what does not work on it?

how do i alter table and ad a unique column that = column1column2?

well that query will select all from those two talbes where the category_id is the same?

i thought it was 'alter table summer add unique check(ip,song);

BlkPoohba, tried with unique KEY?

yes
same error
error at 'check (ip,song)'

BlkPoohba, use `check` with those ticks.. it must be a reserved work then
--which should make you think wether you really want to name the index like that.

nope. same error

how are you doing it?

ok. it must have been a reserved word b/c i changed the word and it worked

whats wrong with this?? INSERT INTO Users User = 'test', Password = '84ff3b565ddfd33fc0b43b61b9cf9e9';

oh. no it didn't

zabi1, insert into users(user, password) values('test', 'lalalala');
btw, for the previous syntax, you were missing the SET

is there a way to get the value of a field for the last INSERT if the insert was done with the auto-incrementer?
on the primary key

rookpawn, SELECT LAST_INSERT_ID(); // if you're on php, mysql_insert_id().

thank you so much

anybody here use tora? How can I get it to maintain a connection to the (MySQL) server?

bribe it, force it, take hostages...
isn't that oracle stuff btw.?

lol

could someone kindly tell me the best web hosting way to run a query on a list of words instead of just one entry at a time.... I am using a php "fopen" to open the file in php

it was originally written for Oracle, but it also supports MySQL and postgresql now

i'd like to run the query and list how many results each entry has

so my info is outdated...
what kind of query?

fulltext index

well, at ths point I'm gonna take the punk way out and be like "hmm I need to upgrade to Feisty anyway..."

Consolidate your thoughts a little bit more.

dist-upgrades to fix individual application problems FTW!

that's vague advice won't help me

Doesn't help us either.

thanks though

hmm with boolean mode you can search for multiple words... I
I'm still all sarge & dapper

I have a list of 10,000 words

yeah, my laptop at home is still Breezy, which should tell you how much of a procrastinator I am
the servers here are sarge, but that's gonna change soon

i need a (free) database of zip codes and their corresponding citys/states

I suppose my question is, is there a way to run the query on one line at a time in the text file
and after each query, record the data in a table

UltraVi01, plenty of ways in your php script

is there a way to convert a DATETIME to seconds within the WHERE statement?

joe-f, unix_timestamp(datetimecolumn)

gracia

you'd better convert your seconds to datetime if you're planning to use it in a where clause. no index would be use if you apply any function to the column

im not sure what you mean, i'm leaving it datetime, theres just one query i need to run nightly, that adds on extra seconds - ie 'swing'.. so it SELECTs all of the records i need

joe-f, is the datetime column indexed?

nope
i see what you mean now tho
it could be indexed, but i wont now that you mentioned it.. makes sense.

can't you use UPDATE directly?

Got a mysql replication going. The slave has no errors and says waiting for master to send event. Master gets updated but nothing writes to the slave. How can I check what's going on?

show slave status shows? did you set any of the replicate-do-* option?

yes I did set some
For the databases and tables

What part do you want to see of show slave status?

hmm just put it into pastebin, if there is anything confidential strip that.
pastebin

try http://pastebin.ca

http://pastebin.ca/562749

so there is a database named master and a database named firewall?

yes
I just want to do some tables in master

what update statement?

and the entire db firewall

very well done

INSERT INTO firewall_policy_type VALUES ('4', 'TEST DO NOT USE');
I see that now on the master, but it didn't update the slave.

alright
that's weird

Yeah
Nothing in the error log.
So I'm trying to figure out where to look

is the slave running? show slave status and check that both the io and sql host thread are running

hey
im getting an error
syntax error, unexpected '{' in /var/www/personal/options.php on line 14

http://pastebin.ca/562749

but its not unexpectedd

sounds php-ish ;-)

Already did.

php error, and it is unexpected

lol
can i pastebin it?

don't call the parser a liar
you might be more lucky in ##php

might be best in a php channel
might be best in a php web hosting channel

lol
its something mysql hosting i think

I don't

youre wrong.

because im trying to read passwords from a database

no, php error message.

lol

It means you have an extra {

mysql isn't even touched.

i bet you i dont have an extra {

as the parser fails before executing the code.

this is not to be rude but to summarise the discussion that will otherwise go on and on and end in the smae anyway. take the shortcut. it's a php syntax error you need to looka t your code and fix u the missing {} stuff

I bet you it's a Syntax error, 50$.

zabin, get a syntax highlighting editor

thats not even a bet
thats good advice

$result = mysql_qurey("SELECT Password, User FROM Users WHERE Password = '$PasswordCheck'" );
$row = mysql_fetch_assoc($result);
if($row[PasswordCheck] == md5($password) {
print "Password correct";
}
else
print "wrong";

missing ) after $password)
needs tobe two ))

you could have earned 25$ by saying that in private

becase of the opening ( for the if

ahhh lol
sorry that was a retarded question

we all get blind. just dont disagree with experience so quickly ;-)
also, you may wish to use mysql_query() rather than mysql_qurey() as the latter function does not exist

yea
i caught that

So...my mysql slave...any ideas? I'm guessing I should dump the bin log and see

then, php will complain about $row[element] without element being quoted
and I'll leave it there

lol Thanks arjenAU

well that actually works
php will treat it as a constant which contains the string afaik
try php echo test; ?

good evening! has there been a date set for 4.1.23? (kind of related to the security fix in bug #27515)

out of live...

it'll chuck a warning from 5 at least.

not E_STRICT or E_NOTICE?

$row[element]? It'll be a E_NOTICE

ssibly but those are good to use too. I always dev with 'em so I don't miss anything that's really a prob through the rest of the mess

sorry, i'm not getting you

nop. I will say hwever that repl do db and such is a messy thing that can cause you headaches. it may well cause this

well it's not really certain that there will be a new mysql 4.1 release...
indeed.

i just read in the policy that security fixes would be 'released'. im probably better off pulling a source tree myself?

depending on severity

b.ii states "goal is to fix all security issues" - should that be interpreted as not severe (enough) security issue?

in extended lifecycle?

yes; http://www.mysql.com/company/legal/lifecycle/#policy b.ii

Well latest news...I do see updates in the relay bin log

it's not that im demanding or wanting it - i have no issue patching it myself; was just curious

However, the queries that aren't replicating are not there
They are in the bin log on the master

check the relay log

I did. That's what I was saying.
No updates there

stop slave; start slave; check again

hmm I just wouldn't count on 4.1.23 coming any soon.

it probably ran afoul of your replicate-do-db and -do-table junk. you should not use that, really.

*sighs*

not saying for sure, just giving probability of cause

roger that; thanks for your time

I understand

Understanding is a three edged sword

taking backups, so I have plenty of time to waste

Stopping and starting didn't help

get rid of the repl junk.it does not reduce the traffic to the slave as it's slave controlled. it just affects what it executes and logs

I have a bunch of machines hitting the slave...very few the master
I don't care if the slave is slow. The master I do

MaxieZ show slave status; on the slave are any of the Replicate_ options set? such as replicat_do_db?

Ok got it working
I had to remove the firewall db

it's stil begging for toruble, those options. see the bugs system, you'll find a few nasties

No, I mean I removed the firewall from replication. I just am doing the tables.

can someone please explain the freaking time issue with this select count(*), 12.9 secs is unacceptable; http://pastebin.ca/562840

Can someone please give me a mysql statement that would delete a table if it exists please??

wietse, drop table foobar;

if exists

Wiz_KeeD, i mean
it wont delete, if it doesnt exist, quite surprisingly

your table's huge.

will still yell at you if it doesn't exist

3.5M rows is pretty uch

how I see a simple example of create one simple function in mysql?!

on innodb, select count(*) requires a walk through the table

LoRez, this query runs 0.05 secs on the same machine in sql 2000
centosian, a walk through
it does
f***cking this db sucks

Wiz_KeeD, http://dev.mysql.com/doc/refman/5.0/en/drop-table.html
Mutexes, how about count(1)?

I've seen a talk where they recommend keeping a count of items in the table yourself and updating it when you add/delete items
it's because of the ACID compliance
I'm guessing your db is under constant use Mutexes ?

yes
ok, then how do you explain this
1 sec

hi what does this error represent?
mysql_connect(): Can't connect to MySQL server on 'z1.wwdl.net' (61) in /home/common-sites/count/stat/stat.lib.php on line 9 Unable to connect to database

tibyke if the table dosen't exist then it return an error...

http://pastebin.ca/562855

What's a good set of options / GRANT / create-user recipie for a query account that can create temporary tables/views?

that table is not undergoing constant writes

if 12.9 ~= log(3xxxxxx) ; then log(130000) is not 0.01
creation of a Member object in code layer involves a query that joins member to contact to location;
in .net and sql 2005, this is done in 0.05 secs, here the member database (same size as its mssql version) has the same runtime values, the freaking location table is f**cked up

the workaround is what I described to you above

GRANT SELECT, CREATE TEMPORARY ON mydb TO 'username';
?

so anyone know a mysql sitax to drop a table if it exists??

centosian, no mysql shoudl handle millions

drop table if exists foo

is "should"
s/is/it/

firewire
genius
3
:*

there's something wrong here
this is not normal

OS error code 61: Connection refused

look at the time difference, http://pastebin.ca/562855 and http://pastebin.ca/562840

that's not a pwd error, that's like a firewall or such
it helps to display errors properly, then it's more clear what's going on

ohh
ok
that is the only error i have back nothing else.
arjenau

sambagirl, first off
where is your server?
do this, telnet yourserver 3306

it's a cobrand mutexes

if it's locatlhost, then do 127.0.0.1 (or simply localhost)

i have no idea where it is.

you don't have a url, ip? anything?

well yes

well you connect to it, the connect string will tell.
or phpinfo() will at least

but they told me the programmer was working on it.

ok so telnet thatURL 3306

did it connect?
if you get firewall error, then it's not your query
i mean your connection attempt, it's the fact that server is behind a firewall

can someone recommend a good mysql book for semi-seasoned mysql users

could not access connectoin on that port. yes i believe they have an issue.

thank you for you insights mutexes and arjenau

return select f1 from table1 where f2=param1;

is that a question?

hum, yes

http://dev.mysql.com/doc/refman/5.0/en/create-procedure.html

I using 4.1 and not have this page
and I think that is tottaly different

i believe they've had create function
but no procedures

define seasoned?
and what kind of info you looking for. query stuff, design, optimisation, admin, development and other hacking?

I've been using it for 5 years but have never had to handle the load I need to handle now
query/design/optimization/scaling

no book really covers that. it's a lot of stuff.

I hoped that wasnt the case
how about just scaling

"mysql deisgn and optimization, from novice to professional" by jon stephens, Apress
and "high performance mysql" by zawodny/balling, O'Reilly
you can't hack formula 1 racecars just by tweaking a screwdriver.
4.1 had UDFs not stored procedures/functions
you need 5.0 for that

what does an error with Invalid catalog name mean?

that you're not using mysql?

but i am

I can't create a function like as in postgres in mysql 4.1??!

error code? context?

SQLSTATE[3D000]: Invalid catalog name: 1046 No database selected

that is correct. feel free to add more exclamation marks and whatever, but it's going to remain the same answer. you are however using a fairly old version of mysql.

and well, it's not as easy as "select a database, silly"...

let's not go into a mysql vs postgresql debate either, because one can also opint ot some stuff that postgresql would be "missing" and whatever
it is actually. mysql_select_db('dbname')

not my script doing it though

you just got your answer.

it's somewhere in the depths of propel-gen..

what kind of site/app is this?
do you create the connectioN? then you need to also do that call, or add the default dbname in the connect

well could you tell me if Invalid catalog name is relevant?

flektor.com
massive, like myspace massive

I not entering on 'debate', sorry, it is only a example, and about version ... my company not use newer mysql versions :-\

it is. you're telling it to use a room (table) in a street (mysql) without speifyig which house
to plonk in a silly analogy

but I need a function and can't recompile mysql

myspace is mostly ugly

i know

myes well the weird part is that it should select it...

so how many pageloads/sec, what size dataset in mysql?
not magically. a mysql server can (and does) have multiple databases.
their problem.

i know but everything is properly configured, coded and checked but it just isnt working

you may wish to discuss with someone like firewire
you are wrong.
an assessment which is backed up by the facts you yourself presented. now stop arguiing and deal with the problem.

the problem is that a script i didnt code isnt doing what it's supposed to do but it seems to be working for everyone else...

perhaps it hates you

perhaps

interesting that you would find that a more plausable cause ;-)

well it's *nix, nothing surprises me...
urgh im so lost

guys, i told you there was something wrong
http://pastebin.ca/562926 -- see fixed
it was a bug with mysql, but i don't even know exactly how to report this bug....

when upgrading mysql do i first shut off the mysql , if so how do i do that?

do you use a package manager?

im going to be using an rpm file
lol yes
sorry

normally it should take care of that.

in debian it stops the server before upgrade, should be the same with rpm.

is there a 'quick way' to remove duplicate rows from a table?

duplicate in what way?

ok ive got failed dependencies

as in, multiple entries with the same username and password

alter ignore table tblname add unique killdup (username,password); alter table tblname drop index killdup;
this is a trick. it creates a unique index, but with ignore so it zaps dup entries along the way. it's very effective and potentiall destructive when used incorrectly.
but you may want to have aunique index on username anyway.
so perhaps just do (username) rather than including the pwd
so you can add it once, and not drop it.
ok?

hi all.
can anyone please tell me how I can setup an unprivileged mysql user and give it access to a certain database? (and set a password for the user?)

i'll just dump the db somewhere else first and try it from that

http://dev.mysql.com/doc/refman/5.0/en/adding-users.html

hmm...nope, not really quite it
guess i'll just clean out the entire database and start from scratch

can you select the duplicates with a sq query?
sql*

i think so yes
the difference between the rows is the time difference by like 2-10 seconds

thanks threnody

glad it worked out.

create table foo like bar; insert into foo select * from bar;
killing dups that way is more tricky, but it can be done with joins in a multi-table delete
ukilling dups that way is more tricky, but it can be done with joins in a multi-table delete/u

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

it's in the manual? or is that what youre' havin trouble with
add -p on your mysql cmdline.

that's what i'm having trouble with

can someone teach me the proper way to upgrade from mysql 4 to mysql 5? i am using redhat rhel4

What is the quickest way to move a table from one database to another?

see section upgrading from 4.x to 5.0 in manua;

i was even using mysqld_safe

how do i find out which SQL command is actually being used when mysqlimport is executed?

PuppiesOnAcid:: create table db2.foo like db1.bar; insert into db2.foo select * from db1.bar;
or copy the physical files but that depends on storage engine and other stuff.
that's the serve rside. nothing to do with it. the above is a client side error cuased by you not specifying -p, so it thinks you want to log in without any pwd.

arjenAU, i cannot login. i typed the password in wrong / forgot it.
so i need to reset it.

to reset it

there's a section for that in the manual, resetting root password. or is this another user?

How do I get the month/day/year of a timestamp?

i already tried what was in the manual it gave me the same error.

if it's naother user, you can login as root and do SET PASSWORD for user@host=PASSWORD('newpwd');

let me try something else. brb

feel free ;-)

I have a txt file with a list of terms... using UPDATE, how can I replace the entries in a column with the values in the txt file

omg.

On the CLI, how do I pipe a bunch of SQL statements in a file into MySQL?

actually, I have already done most of the work -- I have the values as a php var
i just need to UPDATE with the variable

PuppiesOnAcid, source file.sql -- if you are in mysql already, or mysql file.sql

-p****

something like this ? $sql2 = "UPDATE logs SET results = '$counttotal1'";

does the mysql query browser have a csv/text file import option ?

mysql file.sql

the database is on a remote computer

can't you ssh to the box?

im not sure
cant the MySQL Query Browser do it ?

see if you can.

how do i get the file on the database ?

well if mysql file.sql works, then mysql -h myremoveserver file.sql would work too

you can scp it.
assuming the port is open. Unlikely.

if he is considering mysql query browser, it must be.
anyway, how dows it work with csv? I've never done it...

Is it just plain stupid to not have any password set for root@localhost?
Or can it be acceptable?

hi there
I was trying to delete all records from a table which a value is less that the average of all
select * from conta where saldo (select avg(saldo) from conta);
this works
delete from conta where saldo (select avg(saldo) from conta);
do not works

what error are you getting, exactly?

I guess that it can't subquery the same table iirc

You can't specify target table 'conta' for update in FROM clause

store the average value in a temporary table first.

Im begginer in this yet
i dont know how to do

can't you just perform 2 queries?

1) create a table with one field

fixed it .

2) insert the avg() value into it

off to finish mediawiki. bbl

3) delete the data where saldo avg()

meh. perform two queries. it's easier and faster.

thumbs, I will search how to do this
create view virtualsaldo as (select avg(saldo) from conta);
delete from virtual where saldo virtualsaldo;
Table 'banco.virtual' doesn't exist

S4nD3r, SELECT AVG(saldo) INTO @avgsaldo FROM conta; DELETE FROM conta WHERE saldo @avgsaldo;

hi all, where can get, the lastest mysql stable version (yum install mysql-server wont work), i use centos, and like me the RPM file...

@avgsaldo is a temporary table ?

S4nD3r, no. it's a variable.

0220 branstrom» Is it just plain stupid to not have any password set for root@localhost?

how do I replace the rows in one field (of a different table) with another

I need to learn this fast

Erm is there a way to do a LEFT JOIN of data gathered from a WHERE clause?
SELECT table.field FROM table WHERE field = 'somevalue' LEFT JOIN ... .... ... blahblahblah

you're approaching your problem from the wrong angle.

Ok, I'll sheepishly admit that I suppose.
Trying to find a difference between two lists of numbers, but each list of numbers is gathered by using a WHERE clause in the first place.
I thought that was the most appropriate way

and field1 not in (select field2 from table2 where condition2)

HEH!

heh?

Just.... so simple, its stupid.

right.

I feel stupid, is what I'm trying to say.

ok.

Rightfully so, as my first query stipulated.
Thank you for your help, I'll definitely remember that one.

sure.

That's a big IN() search.

is the field indexed?

condition1 == ~3000 results, condition2 == ~3800 results.
No because.... *cough* text fields are used *cough*

I'm working on a query where I get a hostname that ends in a number. I want to get rid of the trailing numbers, but I can't seem to figure out how to make a mysql regexp return the match. Is there a clever trick to this?

alternately, you could do a left join and do where field2 is null
i.e. from tbl1 inner join tbl2 on tbl1.f1 = tbl2.f2 where f2 is null
errr s/inner join/left join

hmmmmm

it's probably faster in that case.

But with that, am I able to use my WHERE clause?

sure
AND ... AND ..

So I have foo12 as a result in a column, but I just want foo. How can I do that?

Ok, I don't follow with the INNER JOIN.

select fool2 AS foo
it should be a left join.

I still need to specify criteria for the two elements of data that I am comparing against.
Yes, sorry.

No, foo12 would be the result.

oh
select LEFT(field, 3)
yes, and put those in the WHERE clause. The global one.

SELECT c.hostname from computers AS c WHERE c.ip_address='192.168.0.1';

But the table names and field names are the same.

then prefix the fields with the table name.

But, lets also pretend that there are more than one length of hostnames.

The table names are the same, it would become ambiguous, no?

um, it's the same table? you never said that.

I'm sorry, I thought that I had.
Guess that makes things different, huh
Can I use AS 'sometablename' ?

sure.
altho I'm not sure you're going at it the right way now.

How would one concatenate the following... SELECT * FROM CUSTOMERS WHERE name or lastname or email or comments = 'some string'; | or better yet, how would one search all the columns of a table for a certain key? I've tried using CONTAINS(*,'keyword'), but that performed weirdly, as it did not return values from half the tables...

if you compare field1 against field1, the values will always be equal

ok so heres a newbie question ... I'm looking to store a hierarchical structure (division, league, team) in mysql ... any thoughts on popular ways to do this. I've found a few different methods of doig this, nothng that screams at me though.

field1 matching some WHERE criteria, and field1 matching some OTHER WHERE criteria

AND criteria2

I don't think LEFT will work, unless I can couple regex with it. Some of my hostnames are longer than others, and some have more numbers than others at the end.
e.g. foooo2

ok then. Define your criteria.

Thanks, I'll pick this up later.

I think I know what he is going for. If I have something like bob12 or bo12 I want to always seperate the 12 and the characeters..

any easy way to get export the structure of a few tables?
to a new one...

Incorrect key file for table '/tmp/#sql_15b7_0.MYI'; try to repair it
anyone know what would cause that? got that error when doing a very large insert

so, repair it
very large means?
and small insert works?

how do you "repair" it?
FWIW, that file doesn't even exist

hm
it's a temporary table

i think i need to increase some my.cnf stuff

maybe you need to increase row pointer size

any idea which setting relates to that?

what size is the table and how many rows do you add?

i think 2mil rows, not sure how to tell the size

you might want to adjust the approximate table size
!man full table

see http://dev.mysql.com/doc/refman/5.0/en/full-table.html

it's an innodb table, btw

ok
what kind of insert?
buffer pool large enough?

Hmm maybe if I ask my question differently | what should I google to figure out the ideal way of searching all the columns of a table (unknown columns) for a certain key?

nils_, i'll try increasing from 16M to 128M
this query takes a while to run

how much ram (how much spare ram)?

2gb ram

spare!
the more innodb tables you have, the more buffer pool you should have

like how much at this moment is not in use?

tables as in tables+data
yep

2058976 kB
42988 kB
not much lol

also check the stuff wasted for cache
especially if most of your tables are innodb

Oh I see - it's rather risky to search 'all' columns in a table as some columns might be a integers, which don't go well with string searches

nils_, this query is crippling my machine at 128M
is that probably too much? i just took a guess
it's not something that will be run often
just once in fact

not too much
you might want to increase log_buffer_size and log_file_size

2058976 kB
16752 kB
nils_, same error

is that the whole error?
how much space free in /tmp?
I wonder why it creates a temporary table anyways

http://pastie.caboo.se/69982
tons

especially as it it innodb

9gb
it's a "insert into ... select ... from"

ah ok
that might create a temporary table
which mysql version?
I wonder why it creates a broken temporary table

5.0.26

hmm
tried with a newer version?

nope
i had some other error with new mysql
so i masked portage (Gentoo) to not upgrade
i can give it a try though

What error is MySQL giving you?
gentoo uses such a retarded configuration file...

Incorrect key file for table '/tmp/#sql_15b7_0.MYI'; try to repair it

wow...
and what is the command you are issuing when you get that?

it's a "insert into ... select ... from" command

well creating a damaged tmp table...
sounds like a bug to me

there are about 2mil rows of geographical data

When I do an INSERT INTO ... SELECT ... statement, how do I insert static values? Like, I want to set some fields from SELECT, but one field in particular, I want to insert 2 for every record.

city name, coordinates, etc
http://forums.mysql.com/read.php?21,50214,50214#msg-50214
appears to be a bug
but upgrading might bring back another bug
i can't remember the other bug, but downgrading fixed it

what is the output of `df -k` on this system?

lots of space
9gb

9gb !== "lots of space"

are you saying that's not enough?
i can run the query and monitor it

I have no idea. You're not providing useful information.
what is the query you are issuing when this happens?
this is the *second* time I've asked you for it )

insert into places (name,type,parent_id) select w.accent_city,'Feature',p.id from worldcities w join regions_fips r on w.iso_region = r.fips_region join places p on r.fips_region = p.abreviation where p.type = 'Region';
the worldcities table has over 2mil rows

pastebin the output of SHOW TABLE STATUS LIKE 'worldcities'; and all the other tables mentioned in this query.

everytime I try to update a table row with entries from another table , mysql locks up
times out

[RainMkr], http://pastie.caboo.se/69985

How much RAM does this system have?

2gb
here is the my.cnf
http://pastie.caboo.se/69982

I'm sorry, can you those again with \G instead of ;

sure
http://pastie.caboo.se/69986

Oh! Bless you!

Ok the output of: EXPLAIN select w.accent_city,'Feature',p.id from worldcities w join regions_fips r on w.iso_region = r.fips_region join places p on r.fips_region = p.abreviation where p.type = 'Region';

http://pastie.caboo.se/69986
there is a better paste

got an indexes on the tables? show create table \G

How would the presence or lack there of, explain the error he's receiving?

how would I drop rows 9379 - 46895

I cleaned up your my.cnf a little bit... http://pastie.caboo.se/69988

http://pastie.caboo.se/69990
what did you change?

misam_sort_buffer_size
and made it look pretty.

[RainMkr]: didn't review that bit. do continue

but nothing that actually changes the server behavior right?

The misam_sort_buffer_size will. Though I'm not sure it will help with an INSERT INTO ... SELECT

oh 128m

Can you get us that EXPLAIN?

http://pastie.caboo.se/69990
it's all there

sorry, didn't scroll down enough.

i tried innodb_buffer_size = 128M and got the same error
i'm going to leave it at 32M
crippled my machine too

I have a database table for members and it has peoples zip code... I want to display the top(most entries in the db) five zipcodes. How could I do this?

ALTER TABLE regions_fips ADD INDEX idx_iso ( iso_country ); ALTER TABLE places ADD INDEX idx_abreviation ( abreviation ), ADD INDEX idx_type ( type( 10 ) );
Then give us the updated explain

sorry for not helping along, i had a bit too much wine today.

Ya lush!

0 am

I didn't realize the state of being a lush was conditional upon the time of day.

[RainMkr]: I'd look up the word "lush" but i'd rather live irc in a respectable state *now*

http://pastie.caboo.se/69991

One who consumes too much alcohol.

hen I do an INSERT INTO ... SELECT ... statement, how can I insert a static value (a number, in my case) ?
^ W

[RainMkr]: ah ok.. that's whats called 'friend' or 'neighbour' here in germany

INSERT INTO tblname (list) SELECT 1, 'hi', f1, f2, f3 FROM tbl2 ...;

Coo

ALTER TABLE wolrdcities ADD INDEX idx_iso ( iso_regions );
Then try and run your INSERT INTO statement again.

okay

If I have a zip field that has zipcodes like '85021-5479' and I want to count how many there are like '85021-%'... how dould i do that? I can get a count(zip) but I want to make it count with a wildcard after the dash
is that possible?

SELECT SUBSTRING( zipcode, 1, 5, ) AS zip5, COUNT(*) FROM table GROUP BY zip5;

ALTER TABLE places ADD INDEX idx_abreviation ( abreviation ), ADD INDEX idx_type ( type( 10 ) )
Duplicate key name 'idx_abreviation'
why would i get that?

select count(zip) where zip like '85021-%'; ?

You already created that index.

oh i see

thanks RainMkr
Thanks but that was jsut an example
I want to search through all the zips

ah
;^)

hrmm [RainMkr] would that workin in 4.x ?

si
ok... night all.

peace
ahh extra comma
works great [RainMkr]

ooo
What did you type to get that snowman emoticon?

I don't see that, but I typed a semicolon, a caret and a close parens
; ^ )

:^)
Damn
Colloquy is a damn good IRC client.

I screen irssi over ssh, so mostly just plain text.

Im having problems logging in as a certain user. It just wont let me in, even though I set the password for that user and grants for the db

[RainMkr], just running the query now
well it runs the whole import.sql script i have

jsoftw; whats the error msg?

what is the difference between ` and '
?

ERROR 1045: Access denied for user: 'autocheckextra@localhost' (Using password: YES)
Which is outrageous

` backticks go around table and column, ' singlequote around string and date

I think I might have to sue the authors of mysql

ah!
thanks

can you gain access as mysql root?

ues
yes

do that, and issue the show grants; command
is this connection localhost or remote?

SHOW GRANTS ;
You have an error in your SQL syntax near '' at line 1
erm...
:/

SHOW GRANTS FOR user@host;
or use information_schema if you want overall info
SELECT CURRENT_USER() may also be informative

show grants for 'problem'@'localhost';
or show grants for 'problem'@'remotehost';

| GRANT USAGE ON *.* TO 'autocheckextra'@'localhost' IDENTIFIED BY PASSWORD '38901d2f25c5f665' |
| GRANT ALL PRIVILEGES ON `autocheckextra`.* TO 'autocheckextra'@'localhost' WITH GRANT OPTION |

flush privileges;

ok
nope...
:/
Its weird, its the first time I have come across this

your second grant statement does not include an 'identified by password'. did you?

i need an mysql guru
im having too much trouble trying to upgrade from mysql4 to 5

ouch
it is this /tmp file
it's hitting 6.1gb already
it's going to overflow

eg? 6.1g tmp file? wtf?

ya
it's going to get a lot bigger

hey, how do i restrict a timestamp field to just the date ?

you can extract the date using date(timestamp)

threnody, is there a way to use NOW() when inserting and having it automatically strip everything but the first 8 digits?
i tried setting the length to 8
but that didn't work

are geocodes best stored as unsigned 'double's?

use curdate()
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html

threnody, thanks

np
I'm done, g'night.

what is that construct where you can append two different queries together?
it's like "UNITE" or something
UNION
that's it...

if my auto int. key got messed up, is there a way to reindex it or recount the rows?
?

How did it get messed up?

I don't know... must have been a row that got deleted somewhere
i just noticed it

What does "messed up" mean?

okay, I'm not going to play your games again tonight

It's not a game

yes it is.

No. You haven't explained what the problem is.
"doesn't work" or "messed up" does not mean anything useful

i think he means his id field

I bet he means that. But he didn't explain what is "messed up" about it.

auto incrementing

And...?

if its missing a row just make a new row from the one thats missing

No...

yeah, I just deleted it and recreated it
thanks

why is it that putting group by 1 in my query eliminates some results? I thought it only grouped similar ones

because you need to group by column names, not values.

my query is $query = "SELECT website, name, description, image FROM WHERE lastminutelink=\"yes\" group by 1 ORDER BY RAND() limit 0,5 ";
what am I making it do here with the group by 1?

GROUP BY 1 does NOT do what you think.

lol - evidently not

you can either GROUP BY website, name, description, image OR use the DISTINCT() frunction

so if I group by website it will only allow one of each website to show?

you can't only GROUP BY one of the selected fields.
Try it.

ah - is it because I was previously using group by 1 with an INNER JOIN?
and it was grouping via the join?

GROUP BY 1 makes little sense in any scfenario.
scenario, too

really.....huh

DISTINCT is not a function

bah you.

how does distinct work?

MSSQL
moving on...

hmmmm - when I was using inner join on several tables I was often getting multiple instances of one client, therefore I was using group by 1

if you wish to GROUP BY website only, you must do something like MAX(name), MAX(description), ... etc
it has to be the only non-altered field in the selection list.

hmmmm - needs to read a good book on msyql

my suggestion would be to simply do GROUP BY website, name, description, image

didn't know that would work
just group by one of them?

no.
ALL OF THEM.

oh, all of them
does that work for inner joins as well?
do you recommend any msyql books?

it would, but I would hope that you would join on unique indexed fields.
if you don't, then it would achieve that result.

WHERE latest_timestamp NOW()-three days ago

I thought that's what I was doing with my group by 1 ;-)

you were mistaken.

evidently
do you recommend any books for novices?

not really. I solely rely on the documentation on mysql.com

If I have a query such as the following, which is comparing rows of a table with other rows:
select * from rev as x, rev as y where x.rev_num = y.rev_num - 1 and x.article != y.article;
Will the time to do that query grow quadratically?

then you must have a better background than me - self taught programmer ;-)

why are you joining the same table, exactly?
perhaps.

I'm looking for two adjacent entries where a particular property differs.
store a versioned tree in sql.

can you get the mysql manual in print form anywhere? or pdf?

http://dev.mysql.com/doc/

thank-you

ok
how many records does your table contain, and are those fields indexed?

Millions, yes.

yikes.

Yeah. Wikipedia.

so yes, a quadratic performance impact is probable

what is the strongest/best encryption to use for passwords SHA1 or MD5 or ?

Can somebody recommend a good reference for these kinds of questions? (what will be slow, what's the best way to store such and such a kind of structure, etc.)

I suspect that altering the table design would dramatically improve the query performance.

I believe it's possible to generate collisions using MD5, but since that's only if you have a digest to collide with, I'm not sure that it matters with password hashing.
well it's not altering yet; I'm just now designing the schema.

namely, storing the revision in a separate table.

separate from what?

the articles table, I presume

Oh, no, this is already a metadata-about-revisions-only table.

oh ok.
I was thinking of designing a left join scenarion.
there is never a case where joining the same table is a good idea.

Basically I have a tree structure with multiple roots (the roots are articles) and I need to have a history of inserts, deletes, and moves of nodes.

on the same field, that is.

including between roots and within the same root.
I should also mention I guess that a lot of MW sites are still on 4.1.

well without getting into too much details,
I still maintain that revisions should maintain a one-to-many relation with articles
and include the revision details in that table.

Well, what I'm versioning isn't revisions of the articles themselves.
I'm adding a tree of 'threads' hanging off of each article.
and I need to keep track of the threads being moved around.
and so the table in question is thread_revision.

How would I concatenate several expressions together? Eg: select month(now()) day(now()) year(now()); as a single string?

not article_revision.
!m CONCAT

CONCAT see http://dev.mysql.com/doc/refman/5.0/en/.html

or maybe not.

Danke.

that url is wrong karsten. check: http://dev.mysql.com/doc/refman/5.0/en/string-functions.html

Actually, date(now()) was what I was looking for.

It's always irksome to see a wiki that's full of errors be restricted to logged-in users.

Try running an open-access wiki these days. How hard is it to get an account?

Wikipedia seems to be doing fine

Wikipedia's got some serious social mass.

Despite the machinations of e.g. colbert.
yes I was joking.

Don't you *dare* slander my hero!

Oh, he's my hero too.
But wouldn't you say he machinates quite effectively?

And everything he's said about elephants is true.
;-)

md5 it is then .. char(32) ?

unless you want to just store the bytes.

what'm i doing wrong here, anyone mind letting me know? i'm trying to set current to 0 if the latest_timestamp is older than 4 days: UPDATE djmccormick_armory.guildmembers SET current=0 WHERE latest_timestamp DATE_SUB(NOW(), INTERVAL 4 DAY);

whats the problem

0 and it's "current" value isn't
oh i think it's mysqlquery browser screwing up on me, i restarted it and it went fine
sorry

hey folk

hi, I'm on gentoo, I had mysqld 4.1, and just upgraded to 5.0. I tried starting the daemon directly, but it complained about the mysql.user table.. (then I realized what an idiot I was for not making a backup.. I have a backup of the /var/lib/mysql dir at this point). if I start mysqld using 'mysqld_safe --skip-grant-tables --user=root' and run "describe mysql.user", Password is a varchar(6) but most rows are 16 characters long.. what's goin

eigma, there's a tool called mysql_fix_grant_tables or something like this

why not install 4.1 again, put that old /var/lib/mysql back, dump, install 5.0, import, $profit
yeah there is indeed such a tool

there is mysql_upgrade in 5.0 replacing mysql_fix_privilege_tables

Password is actually a varchar(5).. is that really correct?
like I said, most rows' Password column contains 16 characters

password is never varchar(5) or 6
it should be about 41 from 4.1 onwards
16 is for 4.0 or older

oh, the irony.. pastebin fails with "Query failure: Can't open file: 'recent.MYI'. (errno: 145)"

!perror 145

pastebin

Table was marked as crashed and should be repaired
try http://pastebin.ca

http://rafb.net/p/WpjlO075.html
http://rafb.net/p/3Cxsa018.html
(underscores added manually)
is it possible mysqld 5.0 tried to modify/repair the tables automatically when it started for the first time with the 4.1 db files?

for a american prices .. we use float or ... ?

I would suggest using integer and storing it as cents, not dollars

decimal or an integer

or I have seen people use decimal. But float isn't recommended

floats float. funny that.

two votes for decimal
hmmmm
I like decimal

I like integer. when appropriate.

wow .. so I'm learnin' to avoid rounding errors from the start .. good stuff
decimal(5,2)
so to update a datetime field on update .. I would need a trigger ?

no, why?

dunno .. how else to do it
I'll just use timestamp and call it a day

insert in my table (mydatetimefield) values ('2007/06/12 05:00:32')
?
i go to bed... bye

trying to connect to a remote MySQL
both servers are within the same firewall
I have skip-networking commented out
and setup a user account with all privs
still can't connect :-(
anything I'm missing?

What is the error?

Can't connect to MySQL server on '192.168.

You're going to have to paste the whol error message...

sorry, missed some of it
Can't connect to MySQL server on '192.168.35.126' (111)

!perror 111

Connection refused

ah!

That helped you?

does that mean the user does not have privs?

very likely

Possibly. Usually you get a different error message

I created the user using the following

not a single user can connect from this client

What distro?

nope
not a single user can connect remotely
it's a brand spanking new setup

What distro?

distro is RH ES4
both of em

Pretty sure you need to poke a hole in the firewall

GRANT ALL PRIVILEGES ON *.* TO 'tphawaii'@'192.168.35.125' IDENTIFIED BY

'xxxxxxxx' WITH GRANT OPTION;

or SELinux

4 doesn't have SELinux

they both are under a dedicated firewall

hiii

how can I check if I can at least connect to the port
is there a way using telnet?

3306

ahh
and that will return what?

If it is a user issue, you'll see garbage
If it is a network problem, you'll see cannot connect

connect to address 192.168.35.126: Connection refused
howz that

firewall

kewl
thanks!

system-config-securttab
It's one of those commands

u talking to me about system-cdonf

I think
my head hurts right now
People changing nicks hurts my head

how could I delete all but the 3 most recent records from a table?

Pretty sure DELETE supports ORDER BY and LIMIT

yeah, that works, but when trying to use a negative offset I get an error, any ideas?

Why a negative offset?
LIMIT 3, 999

DELETE FROM posts ORDER BY id LIMIT -3,

ORDRE BY id DESC LIMIT 3, 99999999

right :P damn.. thanks

Of course, SELECT is a good idea to test first

ORDER BY id DESC LIMIT 3

Wouldn't that DELETE the last 3?

yeah I'll test first dont worry..
yeah its the opposite, I got it now, it works!

hey my /var/log/mysql folder is about 131 gigs, why is this getting so big, max_binlog_size = 100M

Look in it?

seekwill, yeah it is full of files with names like mysql-bin.0000 (bunch of numbers)

Yep. Sorry

is there any way I can select some rows with an offset but without a limit?

missed the "but"
What do you mean by offset?

LIMIT 3, 99999, where 3 is the offset.. I dont like using 9999.., any better way?

If you have consecutive ids without any gaps it's easy to define offset

9999999999999999999999999999999999999999999999
Use that!

lol, seriously, isn't there a less hacky way?

hi, is there a way to set a column to always mirror another one?

What would be the point of that?

it's for a weirdly written admin app

You can use a view or a trigger.
But generally, you're better off fixing the app

found the problem

ughh, i am in the process of re-writing it for my company in python
but meanwhile, i was hoping to hack this into working

it was bind-address=127.0.0.1
in my.cnf
this causes
MySQL to only listen for local requests
thanks!!!

Hmm, didn't think RHEL shipped with that.

exit
\q

Hi everyone. Is it possible to change the max_heap_table_size value via SQL Command?

try SET GLOBAL max_heap_table_size = whatever;
but do it on a test-server first

ok
second
fraggeln:
sec
http://nopaste.php-q.net/301036
there
(im root)

You are obviously not. Try SELECT CURRENT_USER();

CURRENT_USER()
root@%

root@% = root?

yupp

SHOW GRANTS FOR root@%;

oh wait there

root@% and root@localhost are different users

is it SET GLOBAL max_heap_table_size = 128M;
or SET GLOBAL max_heap_table_size = 128;
do i need the M?
salle?

128*1024*1024
SET can't parse M, K or G suffix.
SET GLOBAL max_heap_table_size = 128*1024*1024;
= 128 would mean 128 bytes and it doesn't make much sense

cheers salle

set it to terabytes!

is there a limit ?
seems to limit to 4GB for me on 32bit system
realise that max_heap_table_size has session and global, why is there a need for session

so that you can change just for session and not a global one?

memory table is global, except probably for temporary table

hi
Could you help me about compile mysql c api ?

if session set huge size, create a large memory table, what about session that has smaller max size, can it still use the bigger memory table?

mmm, probably yes ;-)
what is the problem?

I wanna use this function "mysql_connect"
after i compile source code
and check in dll
this function isn't in dll
It shows only mysql_real_connect

then use mysql_real_connect, better

how difference between mysql_real_connect and mysql_connect ?

not too sure, have to check the manual

I have already define USE_OLD_FUNCTIONS in libmysql.c

i thought mysql did provide the libmysqlclient.dll file, do you need to compile yourself
it is libmysql.dll

yep
It's same
but in libmysql.dll It doesn't have mysql_connect

yeah, no mysql_connect there

you mean mysqli_real_connect, dont you?
mind the _i_

it is deprecated
according to the manual
C not php

- -'
it's obsolete ?

kimseong, i know, but just asking

maybe you can reefine it in your application if you have the source

I have source code
And It has this macro "IFDEF USE_OLD_FUNCTIONS"

i check mysql.h, if you define USE_OLD_FUNCTIONS it should compile by right

yep
I alread did it
but
It doesn't have in my dll

hey any function to load up first 50 words in mysql?
in field "hobbies" i got "bicycling running swimming flying masturbating" and so on, how bout i get only first two hobbies, for first two charcters i can use substring but for first words heh?

You should put each of those hobbies in it's own field

I think you can use strtoken
go seperate hobbies by space

seekwill, yep i know, but its not for me anyway, im helping my friend and yes i need seperate things with space, but hm what is mysql command?
let me see strtoken

U should to manage it in your application

there isnt such thing hmm. i dont want PHP to be infected

not in mysql server

ye i mean i want to use mysql for manging it, without PHP

- -'

in mysql there is substring_index

oh man
yep
substring_index

hmm
SUBSTRING_INDEX(str,delim,count)
String as string, delimiter as space and where to stop , hm 50?

test with smaller number, then use what you need 50 or whatever

I think

pretty nice
and i am tottally in love with Mysql Regex

It's depend on whatever you want
two or three
or another
but not 50

how so? i want to accept it first 50 words, splited by " "

is there anyway to tell if a value contains a number

define value

row entry
WHERE term --- not number --

now state what you want to do, what you have tried and any errors you have gotten

He does not want to play your games either

I haven't gotten any errors because I don't know how to do it
I want to select entries that don't contain numbers

so, what parts of the manual did you read?

I can't find anything about it

well, I am sure it shows the avalible operators

Well, would have to clarify if he means "contains" or "is"

i don't see it
could someone kindly tell me if there is a way to check if an entry contains integers

ultravi01, mysql.com/doc string functions

"an entry" string/blob/int ?

string
sorry

regexp or cast it to a number and see what you get

alright
thanks

cast will only work with leading digits

I'd better use regex then

salle I was assuming a clean ish number in the string yes

hey guys
how do I display all users in my mysql database?

select * from mysql.user

SELECT user, host FROM mysql.user;

\o/

select * is evil

nope!
it provides you with wide range of columns!
your command doesn't disclose any access privileges or password hashes!
useless!

ok, thanks

Hi all, i keep getting a strange message on a few of my sites of "no database selected" it only appears sometime though and without any reason, any ideas?

jimboroberts, your code

anyone know here how can i reterive a last record from mysql table ?

how come its fine for most of the time then occasionally does it?

openbysource, define "last"

what ?
last means the last record inserted in a table

last_insert_id()

if there is auto_increment column

else use a timestamp

And last_insert_id is not for "the last record inserted in a table"

salle, cool

last in that connection/script that did it

hello

Relational database model defines tables as sets. Sets have no order so there are no "frist" and "last" rows.

openbysource, as you can see "last" needs to be qualified

Not even that You need more IFs

salle, cool. total_rows=int(cursor.rowcount) and then loop over it.
number of records are not that much so i guess that's okay

I don't quite get what do you mean by the above

just a quickie, can "ndb mysql cluster" v5.0.30 handle node faillures/reboot etc?

hi
how cani set mysql on freebsd machine so i can access it as root using GUI tools

maybe

sall I guess he thinks insert order will be the "order" which openbysource it wont

externa
external

remove bind-address= and skip-networking from my.cnf and grant permission to the external 'user'@'host' and remove any firewall rules blocking port 3306

^^^

i can get the total number of records in a table and fetch them one by one until i reach the last that is == rowcount

openbysource, nono
they may well in in a different order

aah

use order by for a defined order

separate node failures are sure handled

how do i define that order ?

In MySQL world you can use: SELECT ... ORDER BY somethign LIMIT offset, 1; to get rows one by one

ok, I will read up on it.

Is it possible to run two MySQL instances on the same port using two different bind-addresses?

offsets

than the id's already passed.

mmm

Prepare to rea a lot

sure

ERROR 1297 (HY000): Got temporary error 410 'REDO log files overloaded is what I'm trying to solve..

Are there any caveats? I can't get it working on Windows Server 2003. It always says there's a port conflict when I try to start the daemon, even though I've verified the old instance is bound to only one IP with netstat.

mmm, not sure about windows.
don't use windows that much

Me neither, I'm a Debian dude
But my coworker knows jack about MySQL so I'm stuck with this one

I know the socket code too much know
*now
so I know it works

okay so a field like some id that is auto-incremented on each insertion will help salle

It's up to you

openbysource, or a timestamp

There are always different ways

can ya tell me how do i define a field that is auto-incremented on each insertion during create table ?

AUTO_INCREMENT ? ;-)

does the word AUTO ring a bell?

There's manual you know.

hehehe ya salle

Got it
Turns out the IP wasn't bound to the interface correctly :P
Can I bind to more than one IP with bind-address?

1 or all only

with my patch - yes
mm
kind of.
the patch is vaporware, but still, I have a clone for it
though if you pay me million dollars
I can implement that for you soonish
;-)

Eh, at this point, if I can't do it with mainline Windows binaries, I'm probably better off doing some kind of external packet ferrying
Just for consistency's sake
0 AM and I don't feel like being at work
Thanks for the help.

no million

harhar

does this look close?
AND term REGEX '[[alnum]]' != '1'

Hi all, I've just upgraded to Ubuntu Feisty and my replication is broken with the following errors
Failed to open the relay log './lloyd-relay-bin.000259' (relay_log_pos 5961594)
Could not find target log during relay log initialization
Any ideas how to fix this? That relay log file isn't that important cause it was up to date before the restart.

ultravi01, regexp and dont quote numbers and try it and see

yup, that did it!
thank you very much

would reset slave fix it?

START TRANSACTION; *query1*; *query2*; COMMIT; - checking the result on that and doing ROLLBACK on fault.
Does that seem proper?

You can't ROLLBACK after COMMIT

K, I've changed the relay log.info file and the problem remains the same.

if something fails I hope it exits BEFORE the COMMIT

hmm ... you should read more about transactions

this is how mssql would handle it, if I remember correctly

hi
I have transfered a database from my hosting service to a local server

and?

Depending on error it might rollback automatically or continue

steko, cool

but there must have been some problem with charset/collation
it's a mediawiki database, now all accented characters are scrambled
I have the same version of database, same server charset and collation
what might have gone wrong?

user error =

steko, how did you copy it? Perhaps that is where the problem lies.

the only way to make a dump from the original database is using phpmyadmin
and that I used

what error would cause it to continue?

Ah, there is the likely problem, steko.

great

it seems odd that a query that fails in any way wouldn't throw an error and return, no?

phpmyadmin can do strange things in setting the charset.

I exported it as utf8 and imported as utf8. the dumpfile actually IS utf8
the imported database looks the same as the original (same tables, same content, same collations for tables..)

hi everyone
i enabled mysql to listne to external connections now i would like to know if i can use the console based client to access it from an other machine? mysql --host=ip does not seem to work

elaborate

You make no sense, try to rephrase your question and elaborate on what you want, what you tried, and what didn't work. Also tell use what platform you are on and what version of MySQL you are using.

mysql 5.1 Debian linux on the client machin and EL4 on the db machine

steko, make sure your connection collation is the also utf8.

hello! how may i extract part of data based on time condition to port it to another table?

do you still require information?

it is. I'm looking now at mediawiki mailing lists for similar issues

how to select to table?

ing you want to see the avaiable tables or you want to select the contents of a table?

how to select and insert it into another table?

INSERT INTO ... SELECT, see the manual

i used it before...
thanx

Does mysql have an easy way of backing up a database. Basically, I have a php page, and I would like to be able to allow my client to backup their database, by clicking a button. Is there an easy way of doing this, or is it ac ase of just selecting all data, and saving it in a file?
bDoes mysql have an easy way of backing up a database. Basically, I have a php page, and I would like to be able to allow my client to backup their database, by clicking a button. Is there an easy way of doing this, or is it ac ase of just selecting all data, and saving it in a file?/b