CheapWebHosting.co.nz

Domain Search | www. .com .net .org .nz Check ALL

from backup?

Nokao, yes, thats what i wrote.

our backup server exploded
I got only the files

then from the "real" one, not the backup.
the main server

into the /var/lib/mysql/dbname

as you saw , domain.com/ has two sub directories userA and userB i want that each directory access only one database for each of them

i got the phisical files
and i managed to copy them into a virtual mysql web hosting server
and they work, "in read mode"

f00bar80, mysql wont know from which directory it was called, but yet you can define as many users with as many privileges as you like.

but trying to make a mysql dump of that files
generates a database without the blobs
i need to pass throught sql host dump due to the 4.0-4.1 difference between the old and the new server
but the dump don't contains the blob images that, I'm sure of it, exists on the server
they exist for sure cause I saw them with a mysql hosting visual client
but neither the client generates working dump

f00bar80, mysql does not do anything with http, you likely want #apache

Can someone please confirm that php mysql hosting doesnt rollback a transaction in the event of an error in an update / select or other query does it? Its up to you to determine that a problem has happened and rollback, correct?

Heya, is it possible to say something like "SHOW TABLES LIKE bla FROM somedb"?
I'd like to just check if some table exists in some database

toma^: show tables from profit like '%foo%';

thanks

hi

where mysql store error logs in linux web hosting ?

./var/log/ probably

Dynom, nahh the file must end with hostname.err

how do I see any foreign keys a table might have?

find /var/log -name mysql
it depends on your build/distro, but on common-sense builds it's in /var/log/[mysql/]

i've a database on my dev environement : mysql 5.0.27 and i want to import it on a server with mysql 4.0.24 and i've got a unicode if i select a compatible mysql40 on the export option i could import it but with accent issues "é" become "Ac"

Dynom, yeah

how to copy database1 to database2 ?

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 php mysql web hosting you are using.

innodb also has mvcc .. thought slightly different implementation than postgresql
basically the pgsql approach is to "append" and not "overwrite"

lol
is that something I didn't know?

so where innodb keeps a rollback log ..
i was wondering ..
but there was no "" in your post

the whole post was one big ''

ah .. i didnt read through the end
now i did ..
and it becomes more obvious

i want to copy database1 to database2 containing all data and structures , it's hosted on a server runnning redhat platform ... what else

same server?

hi

but i was very suprised when i thought for a second you didnt knew about mvcc

yes

I have no idea

you could make this perhaps with phphmyadmin ? export the database1 and create and import the databese1
*create databse2 and import the database1

how do I use the table name in an UPDATE statement?

:-)
well, we lock database hosting for reads and writes at wikipedia
how could I know there's MVCC?

hehe
do you use optimistic locking?

hi again
how do I use the table name in an UPDATE statement?

!m Kartagis UPDATE

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

UPDATE table SET field='value' where thing='2';

I'm there, but it's not telling me where to use the tablename
oh

There are lot of examples you know

I got it, thanks guys

hey all - can I disable the relay log on my slave somehow?

of course
'RESET SLAVE'
\o/

that's not an overly helpful suggestion :P
that clears out all the master info

if i have a table full of say product codes is there a query i can use to return a valid product code that does not already exist ?

well, relay log is essential for replication
;-)

ah, I misunderstood what it was for
an upgrade of mysql from 5.0.32 to 5.0.42 has broken replication, and re-seeding the slave will takes days :/

aroo? what broke?

lies!

depending on your query, no

best you can do is create a product code in your app and check to see if it exists

steven43126, we dont know your code types so how could we answer that

http://pastebin.ca/561365

my answer also based on the fact that the product code is DEFINITELY not in the table

shabbs, the code type is a varchar 40, i was just wondering if there was a better way other than me creating it and then searching for it

Hi, is there a way of doing TIMESTAMPDIFF() in MYsql 4.0 ?

no, not really

thanks for the info ill do it the old way

If it were a numeric type having a known range, you could.

Convert to unix timestamp and calc directly

did your server's hostname change?

Xgc wouldn't work in this case but il keep that in mind for future!

nope
that file does exist that it's complaining about

The main problem with varchar type is the difficulty you might have determining the next code from the previous.

it did it when I upgraded the slave only, so I reverted the slave and that fixed it, then I updated the master, and the slave error like that again, so I upgraded the slave to match the version, and it's still like it.

If you know a way to calculate the next code from the previous, algorithmically, you can, even with a varchar type.
and the previous code from the next.

hrm, interesting

I'm about to mail the list

know of any reasons why the slave would fail like that?
after a minor upgrade?

ConvertToUnixTimeStamp??

!m Sarkie date and time functions

Sarkie see http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html

is it possible to configure mysql for pam authentication? so that i can use my unix login to get into mysql.

not at this time

that to me?

I believe a pluggable auth system is in the works, but not till like... 6.2

thank you

So Convert Date1 to Unix, Date2 to Unix, Date2 - Date1 = DateDiff, ConvertDateDifftoUnix ?

does someone knows an equivalent of STR_TO_DATE for 3.23 ?

elshaa, CAST('2007-03-03' AS DATE) ?

hi all
how can i convert a database to a different collation

You don't need it

oh right, sorry wrong function

CAST was added in 4.1

oh
Upgrade to 4.1 then

Unless you want to reformat date string

Sane people shouldn't still be using 3.23

yep, I just tried without
seems to do the trick I want

if i dump it normally then change in dump.sql Defaultcharset with ton one i want is ok ???
s/ton/the

I need to upgrade an old FC2 server.

adaptr, google it
i mean adughep

cheers salle

I fairly recently upgraded a Redhat 7 server to MySQL 5 from 3.23
little bit of a nightmare to get the ball rolling, then it was fine

tibyke, well i hae ben and try to cahnge from utf8 to cp1256
but only garbage is in the browser

adughep, dump it without charset data, set db charset, then restore
or you can also use iconv

I assume you're on the user list?

google and mysql.com/doc are your best freinds

tibyke, ok if i have a table in utf8 and one table in cp1256 in the same database
it wont matter when i dump ?

ever thought of thinking yourself?

i like always to work with utf8 ..i have tried dumping and rstore 10 tiems already
i am missing something ..i ggogle it adn used all the examples tehre
dump data is still garbage
when i open it with vi
is ok
no "??? " characters
ok another question utf8 can see cp1256 characters ??\

actually I'm not on any lists

tibyke, i just did a msyqldump -u root -ppass database dump.sql

hostname change :-)

then delete the database name
then CREATE DATABASE vb_data CHARACTER SET cp1256 COLLATE cp1256_general_ci;
then sed 's/utf8/cp1256/g' dump.sql dump1.sql
and restore using dump1.sql
i see only garbage
the data is cp1256
i triyed the same with utf8

domas: it's definatly not a hostname change , the file wouldnt' exist otherwise - that and I'd notice

should i dump it with --skip-set-charset

hi
how can i get column comment?

it is
whats in error log?
ah, that was error log

well, if you're interested, I'll let you know if the list-collective manages to fix it

the file xian-relay-bin.000962 really exists?
then someone changed pid file path ;-)

please how can i get column comment?

5 /var/lib/mysql/xian-relay-bin.000962' definatly

where is pid file?

found

can you start mysqld from /var/lib/mysql/ working dir?

/var/run/mysqld/mysqld.pid
I'll give it a shot - just 'mysqld_safe' from /var/lib/mysql ?

can you strace and see where the relay log file is opened from and what error fails?

I'd need to strace 'mysqld' itself wouldn't i? not _safe ?

strace -f would follow children

mysql is used on this server, that's going tobe one hell of a trace
bmysql is used on this server, that's going tobe one hell of a trace/b

just startup trace is needed

yeah... I guess I could shut down apache for a moment anyway..

also, what is in xian-relay-bin.index?

'./xian-relay-bin.000962'
right, strace time...

it might be loading from wrong directory, hehe

it's possible - as soon as my youtube vid finishes, I'll look
all the databaess are still running though, and they are all in that directory obviously

select distinct(somefield), someotherfield from table; - this wouldn't work as one would expect would it?
I mean, to pull a distinct row it would have to be a distinct (field1, field2, field3) correct?

distinct applies to the entire select list.
What you're attempting above is done via GROUP BY and aggregation.

ok, so even though you say distinct (field1), field2 it's still going to be a distinct field1, field2 combo
which is what i thought, I just wanted to make sure I wasn't blowing smoke before I lectured someone on it :P

tibyke, is not working at all what i am missing ???????

distinct(field), field2 is not valid. But you can use distinct in certain contexts, such as SELECT COUNT(distinct field), field2 ... GROUP BY field2;

ug, does strace output to stderr, not stdout? :|

pookey, strace -o file

MySQL does seem to allow that form, but it probably shouldn't, just as SELECT id, distinct(id) ... fails.
It's possible the engine just converts select distinct(f1), f2, ... to select distinct f1, f2, ...

Anyone mind helping me connect to a server? I've been writing a script locally on this machine, and just ported it to another machine. I pointed the script to this machine, tried to connect, and it didn't fly. Is there something I'm missing here?

it's actually another RDBMs (not sure what, possibly oracle) but I figured the concept was the same
and I know mysql allows certain things that aren't in the standard, like selecting fields that aren't in a GROUP BY

Oracle does allow it.

but it still would only select distinct rows, not distint fields, correct?

Correct.

so the syntax is allowed, but the functionality is not what one would think from trying to use it that way

hin
hi
I have got problem about mysql c api
anyone can help me ?

let me get my crystal ball

thanks

I think it's translated as though distinct(field) is really distinct (separate expression representing the first in an allowed list of values), (next value), ...

domas did you want to see the strace log?

tibyke could you help me ?

if you ask a question related to your problem we can try to help

thanks a lot for kindness

*sigh*

You'll notice that: select field1, distinct(field2), ... generates an error.

interesting

Now i'm use c api to make own business
I'm using visual studio 2005 to make program
then
I have many dialog in my application

enter

The enter key or return key is not a substitute for punctuation. Use a period '.', comma ',', colon ':', semi-colon ';' emdash'--', or elipsis '...' instead. In other words: DON'T HIT ENTER UNTIL YOU'RE DONE.

I have new one object of mysql from first dialog
and pass it to another dialog
when i using it in another dialog
my memory growth
I don't know why
I have done with mysql_free_result and mysql_close
But my memory Still growth
Could you help me to find the answer about it ?
between connecting of dialog I use dynamic link to call dialog
shabbs r u here ?

yeah, but I know very little about the C API so I'm no help
someone else might know though, give it some time

okie
thx

domas well, looking at the strace, it's opening hte corect file

can anyone tell me if there is a relatively easy way to draw a database relationship diagram from tables within mysql?

try workbench, it's in alpha though so has a lot of issues. or dbdesigner (precursor to workbench) works pretty good

and there is a fork of dbdesigner on sourceforge

you konw... I think I've figured out what might be going wrong...
workbench is awful at the moment, tried it 3 weeks ago

how do those work? do they have to be on the same server as the mysql db or can they be on a diff. machine (like client-server) ?

there is also a free trial from a company called microOLAP, the one I tried was good, didn't wanna pay for it though
they can be on a different machine as long as you have remote access to the server

I have a /var/run/mysqld/mysqld-relay-bin.index and a /var/lib/mysql/xian-relay-bin.index - that cant' be right can it?

thanks I was just trying to figure out if I had to set up mysql on a server with a gui interface or if I could use an existing linux server that is just shell based

what are the dates on 'em?
nah, you could run your diagramming software from a remote windows box if you wanted to

hi
is it possible to replicate innodb to mysql tables?
myisam that is

wibble

well I use osx but could resort to a windows vm if I had to

well, both recent.. but I'd expect that... the xian-relay-bin.index was last modified yesterday, the other today

so it sounds like the consensus is to use dbdesigner for this purpose?

and let me guess, you updated between those two times?

yes.... I think I need to figureo ut how to tell mysql to use those older files...
or.. move them into the new place.. that might be better

did you run an etc-update after your update? (if you used portage that is)
bdid you run an etc-update after your update? (if you used portage that is)/b

I did, no changes... that Inoticed.... but...ermm.. could well be me

yeah, or the fork archivist mentioned
well check your config for the relay-log setting and see if its different

do you know what the name/link for the fork of dbdesigner is?

or if its not set, set it to your original name

After an accidental dmp restore, I have tons of identical lines in a table (their is no primary key in the table to avoid that). How can I remove all stricly similar lines ?

duplicate
dups

I beleive it's as I mentioned. DISTINCT is a set quantifier and involves no ()'s. So if you use the ()'s around the first row value, it just seems as though the DISTINCT is being used as a function, but it's not.

duplicates
wtf

you have an error in your syntax near 'wtf', what the fsck are you on about?

dupes

find them with select count(dupefield) as qty,otherfields from table group by dupefield having qty 1

aha

it's not actaulyl specified in the config - and I don't have access to an older install now to check what its default was.. to compare it to what it is now
bit's not actaulyl specified in the config - and I don't have access to an older install now to check what its default was.. to compare it to what it is now/b

dupes is a misspelling.

well you know it named it xian-relay-bin instead of mysqld-relay-bin

htat's a fair point

replying to me ?

ok, gotcha

Talking to a bot?

lol
ok

bot

I'm *not* a bot! I'm a real buxom wench

mysqladmin variables | grep relay-log shows nothing... I think I'm missing something here -

do you know what the name/link for the fork of dbdesigner is?

mysql workbench, it's on mysql.com somewhere

no, there is another fork

oh, sorry

yeah I thought they told me workbench was awful?

since the GUI team is taking their precious time with workbench :P

Silly dictionary allows dupe as duplicate.

!man relay-log

see http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html

interestingly enough its called Dbdesigner-fork : http://sourceforge.net/projects/dbdesigner-fork

doh!!
thanks everyone you have been helpful!

I'm making progress, but the master has started logging it's binary logs to the 'new' location in /var/lib/run too now! this is just a mess

hi, for a mysql server node, is a cluster of cheap machines better than a single powerful machine?

I love the way gentoo will change defaults like this, it makes server admin so much more fun and time consuming!

hmm, is there anything special that needs to be installed to use "SET PROFILING=1;" and such? I'm running 5.0.38 on Ubuntu, and I get ERROR 1193 (HY000): Unknown system variable 'profiling'

TJCRI, http://sourceforge.net/projects/dbdesigner-fork

thanks for your help BTW, I think I've pretty much cracked it.... maybe
well... kinda... I think I'm in a totally non-recoverable mess, but atleast I understand *why*, so that's something

hi
someone known about mysql c api ?

np, hopefully you can get it to work

yes

oh lucky
!!!
I have the problem about memory leak when i using mysql c api
my application uses mfc

are you freeing results and connection?

yep

Ok maybe I'm under thinking this, or maybe over thinking it... But I want to search all my tables, and all the columns, for a certain keyword. Something along the lines of 'select * from * where * = 'my keyword';'

after I get the result
all the time i use mysql_free_result
after I used mysql_real_connect
I used mysql_close
but

has anyone used the new query profiler?

my memory still growth
My situation is
connect and disconnect
connect, query, get result, disconnect

Yah I'm under thinking this, because I need to return the table...
back to google I go

connect, query, get result, disconnect
at the same object MYSQL
after query
my memory was growth
and If I run mysql_close
my memory has reduced
but in the second or third
It didn't reduce

you could do it with a store proc, or with an application
s/store/stored/

hi
I have a problem with mysql replication with 2 servers, all is read from binlogs, database creation, inserts, updates, but not the create tables, have you an idea that can help me ?
thanks

is there a way to have a select whereby one column inner joins to a table in a different database?

db.table.fld

what percentage ratio of the servers overall memory should be set to the mysql query cache?
10%? 20%?
and why does my.cnf contain 2 lines of text

you answer to me ?

no

jbaline r u there ?

how to tell which config file mysql is using?

the start of a log file position is 4 in master logs isn't it? not 0 ?
'Seconds_Behind_Master: 0'
I think I owe you a fwe cookies

i edited /etc/my.cnf on the understanding of it being a global file with other domains using local versions
i did query-cache-type = 1

LOAD DATA INFILE '/www/readytoimport.csv' INTO TABLE customers CHARACTER SET utf8 FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"'; it tells me there is an error near CHARACTER

and query-cache-size = 20M
still says 0 though
(i've restarted mysql..)
4.0.4, any ideas?

4.0 Doesn't do charsets.

does trigger works with 4.1?

No

seekwill, I'm using mysql 5.0.37

`Mace: Upgrade! 4.0.4 is ancient!
Cool!

I have a problem with MySQL 5.0.26 on a amd64 using more than 4G in the key_buffer. It crashes with a signal 11 error. I read that this is a known bug, though i have not been able to find many references to it. Can anyone point me to more info on this bug and tell me if this has been fixed at some point?

if I am just installing mysql server from a .rpm (its just for testing purposes - nothing fancy) do I only need to install the server rpm? ie: MySQL-server-standard-5.0.27-0.rhel4.i386.rpm

seekwill, that should support character sets, no?

64-bit?
Sure

yes

Everything 64-bit? Hardware, OS, MySQL?
Why do you want a 4GB key_buffer?

4.1.20 actually if it makes any difference. 4.0.4 is the other server..

Everything is 64 bit

(i think.)
so anyway - why?

`Mace: Verify, don't think.

it should be set on?
read don't judge
You're absolutely right, * Added seekwill!*@* to ignore list

here come de judge...

n/m i'll figure it.

I just need it. My database is large and a lot is in the index

nevermind my question I decided to use yum install mysql-server

Don't quote me, but I believe key_buffer is allocated per connection. I can't find my guide that explains all that though. And I'm in a conf call

http://bugs.mysql.com/bug.php?id=5731

awesome

I'm using space on a server that I dont' have root access to
the mysql database running on it does not support federated tables

ok very basic question... if I have a .sql file from MySQL dump 10.8 how do I import it back into the server?

is there a way to compile and use a mysql server with federated table engine in user space alone?
from the mysql command prompt, the source command

mysql --user=... mydump.sql

output_from_query.txt

you can start the mysqld as you own users if you don't need access to the other data
mysqld doesn't need root-privs to start

cool

ok well it looks like this dump is just a bunch of tables (which I want to put into a seperate schema so I can do the dbdesigner thing)... how do I tell it to accept this .sql file but put it into the new schema I created?
say I created schema "newschema" for example
and I want to put file.sql into newschema

i am dumping a DB which contains guestbook coments (blob) fields. When i import it back in, i get something that looks like hex in those fields.

That looks like something i can use... reading it now...

bah

TJCRI I'd use a good text editor (IDE) and manualy change what you want to do, or write queries to do what you want from the existing tables

also http://bugs.mysql.com/bug.php?id=5109

when I do a LOAD DATA INFILE, how can I output the warnings that it generates?

create a table from the original and then alter it to drop that column if you don't want it

well my ultimate goal is to get a ERD of this .sql dump ... however I was thinking putting it into a new schema because I dont want the erd to include the mysql db nor the test db

no need to compile, just bick the binaries (tar.gz) from dev.mysql.com/

and I guess when I say "schema" I am really meaning db in mysql lingo

schema is fine, that's the official word for it

show warnings;

CREATE SCHEMA ... is the same as CREATE DATABASE

ok thats good to know

no one can help me ?

hello.

hi

weigon_ I have to compile to get federated engine support

Can I have more than one password defined on ~/.my.cnf depending on the username?

can i use an or switch in sql?

Has anyone used the new query profiler (http://dev.mysql.com/tech-resources/articles/using-new-query-profiler.html)? I have 5.0.38, but I get ERROR 1193 (HY000): Unknown system variable 'PROFILING'

look at the CASE statement
!m illegalc0de case

illegalc0de see http://dev.mysql.com/doc/refman/5.0/en/control-flow-functions.html

well I am using v4.x and it doesnt yet suppport schema.. but I did make new database

thanks

ok so someone said I can do import source from the mysql client... I did a "use newschema" and now I want to import using source from mysql client

!man source

see http://dev.mysql.com/doc/refman/5.0/en/batch-mode.html

the command is 'source' with file as a param

my MySQL 5.1.17 has federated compiled in
| FEDERATED | YES | Federated MySQL storage engine | YES | NO | NO |

source file.sql; ?
thats it?

so If the .sql file is in directory you were in to start mysql client, simple 'souce myscript.sql'
that's it

simple! thanks

I'll try, how do I find out what ver of redhat this server Im using is running

hey

it worked!

just pick the tar.gz (generic) and it works

profiling support is only available in Community, not Enterprise

now to get the ERD builder

is the default mysql server in Ubuntu using the Enterprise edition?

i have a problem with dumping and importing a DB. The blob fields become "garbled", i.e. the text in them looks like hex after import.

don't know

does mysqldump output binary format?
cmyk ^^^^ for you

well thanks for replying.. is there any easy way to tell which one i have installed?

i used cocoamysql and phpmysql to dump it

cmyk or maybe using format() function to keep data type known

select * from table where col1 like 'stringLetter1%' or col2 like'stringLetter2%' or col3 like 'stringLetter3%';

the rest of the dump looks okay, only those blob fields don't

http://www.databasejournal.com/features/mysql/article.php/10897_3110171_2
very useful^^

the STATUS command will probably tell you

thats to ToeBee sorry^

BadMagic thanks.. i'll check

how frustrating it is to try to download mysql server from that site and receive errors about hxplay or realplay? sheesh

very annoying
those darn plugs

looks fine to me

ok thanks

mysql exports them in hex, right. you can use --hex-blob to enable this
--no-hex-blob to disable it
MySQL can import them just fine. Using hex is a safer encoding

i can use cmd line on that remote server
i cannot, i mean

and ? mysqldump works remotely

query caching is soo cool

why not? -hremote.host -premote.host.port

oh

what is the problem with hex-dump ?
mysql can import such a dump just fine

nothing... just haven't used it i used the guy cocoamysql

hello team
i'm using InnoDB

and there is no option for the --hex-blob

and after crash when i try to restart mysql ... it started
but one tables is saying error in frm file

gui not guy *sigh*

I use MySQL 5.1.x, --hex-blob should be available since 5.0

how do i repair innodB tables ? frm files ?

innodb has autorecovery, just restart the server
if the frm file is broken, get the one from your last backup

!man remote setup

Sorry - I have no idea what function you're talking about! but try http://dev.mysql.com/remote setup

the_wench fails

hehe I am trying to find out how to set it up to allow remote connections

if you don't have a backup, create the table in with the same CREATE TABLE statement as before under a different name and move the frm-file to the old name ($ mv foo.frm tbl.frm)

hmm... she DOES have a tip on that

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

!man external

see http://dev.mysql.com/doc/refman/5.0/en/external-locking.html

if you don't have a backend nor the original CREATE TABLE stmt, you are screwed

I think thats all you get

well that will help

:-(

is there a way i can dump my access database files into mysql?

for the usr@host part.. does the host represent the users ip address?

you feel sad because you haven't done you backup last week ?

dev.mysql.com

yep

ok thanks

yeah tahts the one i am using and i am having problems

!man grant

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

yes!
haha

okay... weigon_ i am able to dump the db via mysqldump
but, it's dumping the blob text content in binary format

because blob is binary, how else would it dump it?
aside from hex
:P

why then, is it not hex in the current blob field on the sever?
it's only turned into binary (sorry, not hex) by dump

because it's stored in binary format in the field, it's just when you dump it to a file it has the option of doing it in hex
on the way back in it translates the hex to binary

okay... problem is, when i import it back in... i only get the binary stuff back when quering it
not the text

can i update from latest .bin file ?

when I do a grant all on database do I need to flush privs?

what text?
shouldn't have to

the text in the blob field
okay.. maybe i made the wrong desicion using blob for text. :-\ (back in 2002)

thats strange I think dbdesignerfork was trying to connect to it on port 10006
well no its trying the right port thats the error number because it cant connect
haha it would help if I wrote the right ip address

shabbs, i have text in a blob field and when i dump it and import it back in i get binary content instead of the text. where's is the problem?

odd
not found exception handler only works for select not update

right now... with the current db on the server selecting one record shows me the correct text content of the blob field
do i have to just change the structure from blob to text?
and then export it?

you might have to
not sure where the problem is

so blob is *not* used for text content

no, that's what text is for

i wonder what gave me the idea back then
that's what i just read in the manual

I mean, theoretically you can
buy why would you?

to save bandwidth?
dunno
that did it! i just changed the field to text and dumped again.
thank you shabbs

sweet I was able to use dbdesigner-fork!! thanks for everyones help
this channel is by far one of the friendliest bunches I have met

np
friendly++

yum install mysql how start it?

most likely /etc/init.d/mysql start

shabbs yes or service mysqld start right?

that would probably work too

both not work
/etc/init.d/mysql: No such file or directory

is that CentOS 4 or Red Hat?

centos

or suse?

i am installd bad

one more question... how do I see the table definitions from mysql client?

did you install the client and server? yum install mysql-server

show create table tablename; or desribe tablename;

yum install mysql (i think only installed client)

/etc/init.d/mysqld start will work for centos

as long as you install the server too

yum install mysql-server

yum install mysql-server
that will work, I just did it

not

understand this - centos 4 install puts the kill script in the right place, but does not always write the startup script links in the proper run level directories. It may not start on its own after a reboot.

I didnt even need to reboot
ohh sorry
I didnt test that out after a reboot

ok

but I do have a running version of mysql5 on centos 4 that starts after reboot

after reboot worked?

yeah I cant remember if I used yum install for that or if I source compiled it (thats my web mysql and its been running for 6months now)
I have rebooted that machine (for mysql5) and it has come up without major problems
I use the redhat chkconfig --list mysqld I believe to make sure its set up to run levels correctly

ok so i found a problem why i cant connect... i need to add my user to the mysql server... how do i add the user and the IP i am connecting form?

back to the describe... I get an error on one of my tables when I do that.. what would it mean? (dbdesigner had problems reading it which is why I used a describe on it)
describe Procedure;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Procedure' at line 1

TJCRI Procedure is a reserved word you could try `Procedure`

well what dingbat used that as a table name
thanks that worked! but I don't know if dbdesignerfork has the ability to do that

the_wench++

karma the_wench

I have the_wench with a karma of 9

karma shabbs

I have shabbs with a karma of 5

aw

karma archivist
aww :P

karma archivist

I have archivist with a karma of 18

hehe

doh
you might wanna do a trim on that :P

yup

could be worse
karma Therion

I have Therion with a karma of -43

that was him playing

pid, qid, eid, aid

alter table

...

aroo no real need dont select * its evil
evil

evil is clearly defined at http://www.parseerror.com/sql/select*isevil.html

Guess I'll figure it out on my own then!

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

fish

Give a man a fish and you feed a man for a day, tell him to go get his own f$%*ing fish and he\'ll either die or learn how to fish, either way he\'ll never bother you again." -- MHillyer

hi
yum install myslq-server when i try start it: service mysqld start say me these error: http://rafb.net/p/K0merM24.html any advice?

a mysql server install is supposed to create the system user account named 'mysql'. Did it?

unless he learns how to fish and gets tired of eating fish and wants rabbit and wants to know how to hunt for wabbit

can't hunt for wabbit. it's duck season

haha

great timing!

karma TJCRI

I have with a karma of

boo

Shrews shabbs Im actually repairing a 193x duck shoot

Is it possible to make a prepared statement remembered throughout all connections?

any guru want to help with a query optimization?

ie. make a prepared statement permanent

!m a-l-p-h-a explain

a-l-p-h-a see http://dev.mysql.com/doc/refman/5.0/en/explain.html

http://hashbin.com/66e.html -- need some help with moving that min() into one select statement... it's causing my query to double in time.

archivist always has the neatest things

Ive only got the gear box

What kind of query?
What's the query?

I'm asking in general really

Has anyone here built Mysql in 64-bit for an intel OSX machine? (i.e.- x86_64 for OS X?)

what's the problem?

I've been googling a bit, but have come up short.

you could make a stored procedure/function

yeah, that's what I've read

Or a VIEW

a view?

Depends on what you're trying to do

a vista if you will.

mm
nothing dynamic I guess

I deserved that I guess.

you uttered the v word, it's punishable by stabbing

nessup- I was using the configure command on this page: http://dev.mysql.com/doc/refman/5.0/en/mac-os-x.html (last comment) with only the x86_64 arch enabled, and it crashes somewhere in the build (let me try again, and I can give you the exact error). Essentially what I need is a 64-bit version of the client library, but am unsure as to how I would only build the client lib (libmysqlclient)

--without-server
may work

erm, you're always building the client library I believe

nessup, I realize that- the thing is- I dont need everything else.. I only need the client library.

hi people

You can copy it out once the build is finished

i'm using xamp for windows

that would work great, if I could get the build to finish

so wamp

and i've installed mysql front

a copy of the error would be helpful

hi
http://rafb.net/p/Kty3b177.html
can anyone help me find out my syntax error?

mysql front? that thing's ancient

nessup, getting it for you now (had to re-download the source)

but i don't know what's the password?

mk.

default password ?

"ken sent me"

full error would be helpful

ok

!m DanyWalker post-install

DanyWalker see http://dev.mysql.com/doc/refman/5.0/en/multiple-servers.html

damn it
!m DanyWalker post installation

DanyWalker see http://dev.mysql.com/doc/refman/5.0/en/post-installation.html

that one

thanks shabbs

http://rafb.net/p/x6teX057.html
with error

my guess is you inadvertantly put a newline character in there
or a space

so i should try to feed it as one line?
cause this represents the backup from another server

certainly seems like there should be no break in binary data

ok
ill try it thanks

strange.. it seems to be going much further into the make than it did last week..
fingers crossed.. maybe it will actually work this time.
wow.. it worked.. I musta done something stupid last time.

hmm
hi all

does timestmap update it's value on update's as well as inserts or just inserts ?
and is there a way to tell it not to get updated on update ?

Just use DATETIME and manually insert the date.

yeah thats what i was thinking I'd have to do

Easier than relying on automagic

How do I go about importing a .SQL file from phpMyAdmin using the MySQL command line?

any luck?

ty for the3 help, it mustve added newlines

Phuz, mysql -u user -p dbname blah.sql

nessup, yup.. its working fine now..
I have no idea what I did wrong last time, but I now have an x86_64 version working on OS X, and my 64-bit app that uses libmysqlclient is compiling fine agains it.

Glad to hear

good afternoon
someone here know how too rebuild a master.info file?
from a existing master?

is there a way to only select distinct data from a mysql table, like if I know it's gonna return mutiple copies of the same entry I want but I only want it to return 1 entry
?

SELECT DISTINCT ... FROM ...?

in pgsql we used select distinct on (a) a from b where c = f;
that sounds about right

Well, if there are multiple 'a's, which one do you want?

hi need like two secs of help if poss

Not possible

meh

seekwellseekwell, all of them that match my where clause without repeats of redundant data where a is identical across rows
bseekwellseekwell, all of them that match my where clause without repeats of redundant data where a is identical across rows/b

need to throw lines into mysql
but Im unsure if I'm doing it right

Well, try DISTINCT

I just did, lol
and thank you for that

INSERT INTO phpbb_config (config_name, config_value) VALUES ('wpm_enable', '1');
(got a few lines like that)

And?

i've done this before, but having problems

Like?

mysql throws errors

Like?

one last tip though seekwell... af f!#* it, I just realized I could solve that next one with... wait no
hmm
ok I have to ask, I am dealing with timestamps on this one
and I am only concerned about distinct on YYYY-MM-DD

Which date do you want?

is there any ways to make it to a distinct listing of that part?

What are you concerned about?
DISTINCT will return distinctive rows... not parts of rows

sw - whenever I put that line into the insert box
I get

I need to know all the dates in the table, but with timestamps, two entries a second or less apart have different time stamps

how can I set max_allowed_packet? I'm trying to import a .sql like this: mysql -uroot -p -Dezd DataOne_IDP_20070605110517.sql but I get an error: ERROR 1153 (08S01) at line 1: Got a packet bigger than 'max_allowed_packet' bytes

Error
SQL query:
(
config_name, config_value
) VALUES (
'wpm_enable', '1'
)
Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'config_name, config_value) VALUES ('wpm_enable', '1')' at line 1

It worked on my local test server, but not on the production one. The file is about 9M

so is there a way to get the date part of a timestamp?

Really, don't paste that. Looks like you're missing the whole INSERT part
Increase the max_packet size

hold on then

I just answered the question

help, I need to rebuild my maser.info file but I dont know how

I thought that had to be left out _
as in you INSERT the bit I pasted

./time

Guff:

argh
even with that, it fails

Paste the query as one line

theres a line in the box already - just leave it be?

Paste the query here, as one line

INSERT INTO phpbb_config (config_name, config_value) VALUES ('wpm_enable', '1');
that you mean?

Yes. Did you paste that exactly into phpMA?

that was the question...how? where?

SELECT * FROM `phpbb_config` WHERE 1
(yes)

In my.cnf
[mysqld] section I believe.

?

http://rafb.net/p/MGuBza94.html

also throwing a nice little `unset HISTFILE` on the command line is good for bash logging although I new I was the only one on the system when I ran the command

meh _
seek - am I just missing the plain bleedin' obvious with this?
I thought I was doing things right

What is the error message?

2 secs

1
2
3
4
5

ha
(server slow)
Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO phpbb_config ( config_name , config_value ) VALUES ( 'wpm_enable' , ' at line 1

Delete the stuff before INSERT INTO....

I tried that also
2 secs
bah now it works

asd

I have to do like 5 lines
so just delete then re-paste for each?

Yes

excuseme

I have a column that looks like "12,14,16,13,22,43,23", is there anyway to do split on that and return each item as a record?

why whjen y create a table tipe inndb, then the new table appear as MyISam , why?

!tell perljunkie about normalization

perljunkie http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html and http://datamodel.org/NormalizationRules.html and http://mysqldump.azundris.com/archives/20-Nermalisation.html and some here http://www.keithjbrown.co.uk/vworks/mysql/

You probably don't have InnoDB enabled

how i enable innodb?

right cheers seek
I'll do the rest of the coding and cross fingers

seekwill, how i enable innodb?

how can I mark every single row 1 with approved column I set it to int, and its 0, I should probably set default value

I don't even see a my.cnf anywhere. There is a /root/.my.cnf could that be it? it has only 3 lines in it

DanyWalker typically you un-disable innodb since it's enabled by default

Hmm... I thought Gentoo did something like not even compile it in...
Assuming he uses Gentoo...

is there a way I can do a select statement where I select upto 10 entries for each key? like I am joining two tables one contains lets say department and the other contains employees and department but I want to select upto 10 entries for each department does this make sense?

subqueries, the table variant

seekwill I hope not
althought nothing would surprise me with gentoo

oh
http://picasaweb.google.com/trailexplorer/20070610

innodb is enabled in gentoo
there may have been a version back in 4.1 where it wasn't compiled in or enabled by default, but it's been in (and set as default) for a while now

Gentoo still sucks

I still use it in places, but I switched to kubuntu

rhel4life

win31-4-life

Hello, any ideas why I would get a #1064 for INSERT INTO clients (`client_type`) VALUES ('C') WHERE `client_name` LIKE 'Contract Account'
cant see any reserved words?

no where clause on an insert

aha

how do i replace the database on the server with an sql file on my computer. i have the upload script on my website that uploads the sql file to a temp dir. but then what do i need to run to do the db replace?

!m opalepatrick update syntax

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

cheers

henke37 how do you suggest?

thanks shabbs - what a dunce!

select * from (select * limit) join (selec * limit)

k thanx

anyone?

remove the existing data and then load it

ok but whats the command to do the import?

hello

hi

i have a strange problem
mysql is giving me error 145

illegalc0de, just use any mysql client that can take a file listing the commands to do

Table './mediawiki/searchindex' is marked as crashed and should be repaired

so repair it

"repair table searchindex" doesnt seem to help

hey, im using relevancy on a full text search, but the results seem all wrong, any idea why that might be?

repair table searchindex;

+-----------------------+--------+----------+-----------------------------+
| Table | Op | Msg_type | Msg_text |
+-----------------------+--------+----------+-----------------------------+
| mediawiki.searchindex | repair | status | Table is already up to date |
+-----------------------+--------+----------+-----------------------------+
1 row in set, 2 warnings (0.00 sec)
mysql

im searching for one word, and it shows up in one row many more times than in this other one, but the other one has a higher relevancy

it still claims it's broken

flush tables?

how?

flush tables;

and show warnings;

hi, I have problems with encodings when upgrading to mysql 5.0.40 (from mysql 3!). Import of data dumps seems to work, but when trying my old webapplications (php), data is returned as utf-8 (instead of latin1), what breaks my old apps any remedy to this? thanks

doesnt help;

mysql -u username -p dbPassword filename.sql

| Error | 145 | Table './mediawiki/searchindex' is marked as crashed and should be repaired |
| Error | 1194 | Table 'searchindex' is marked as crashed and should be repaired |

any ideas?

there anything i can possibly do?
to save my data, that is...

REPAIR searchindex will attempt to fix it. This is a myisam table right?

don't know; how do i find this out?
repair seems to think all is ok
i'm running mysql 5.0.32-Debian_3-log

If you don't know then it is most likely a myisam table because that is the default when you create a table. There is a SHOW command that I don't remember right now to tell you for sure.

"describe searchindex" doesn't work either

Okay. So you are getting the error message when you attempt to access the table?

error 145 again
yes
but repair seems to think table is good
???!!!!

Give me a minute to refresh my memory about the repair command.
Try REPAIR table EXTENDED
Note, the SQL REPAIR statements are just call myisamchk. You can try running myisamchk from the command line, but make sure you shutdown the mysql server first. There are lots of command line options that you can see with "myisamchk --help"

Let's say i have a products table: (id, product name) and a sold_products table: (id, prod_id, price). How do i find out what products haven't been sold ?

well
it doesn't so much call myisamchk as they both use the same code

Okay.

EXTENDED doesn't help....

SELECT A.A, B.B FROM A LEFT OUTER JOIN B USING (A) WHERE B.B IS NULL

great, thanks , all i've come up with is SELECT A.A FROM A WHERE A.KEY NOT IN (SELECT A_KEY FROM B) which is just grouse
thanks

Can't you have a function as the default value?

what are the "test" files `hostname`.lower-test mysql daemon attempts to create during startup?
(trying to start mysql with datadir on read-only partition and screwed up because of this)

"myisamchk -f searchindex" seemed to help
thanks!!!!
Do you think I should prehaps move mediawiki installation to postgres?

your asking in the wrong channel

how do i show the keys on a table?

I know this may sound weird... is there a MySQL command to find the filesize of a table in my database?

The|Navigator, I'm not sure if it represents what you want, but try SHOW TABLE STATUS LIKE 'yourtable'; there are data_length and index_length there.

hello, simple question quickly, how to do a search in a whole database ?

wrong question

Is there a command i could use directly to get JUST the filesize as a reply?

you'd better search for something. I've seen it before implemented in PHP, querying the db.
byou'd better search for something. I've seen it before implemented in PHP, querying the db./b

The|Navigator, may not be sensible with innodb tables

hello
I'm a newbie and I need to distinguish my msqld prompt between mysql on my server and mysql on my client here on my home setup.
the --prompt=("\u@\h) changes the prompt on my client to "(root@localhost) [(none0]+

how do i delete an index?

SirFunk, drop index indexname on table;

Where do I put the max_allowed_packet=16M directive in order to allow the import of a large file?

thanks

aaroncampbell my.cnf [mysqld]

How do I make the h variable reflect the hostname of the machine I'm running mysqld on?

I don't seem to have a my.cnf anywhere.
I ran a locate...and got nothing

-hyourhostname

I know the answer to that aaroncampbel on my box its in /etc/mysql
thank you shabbs
I'll try ti
I'll try it

doesn't exist on my RHEL box
But that's where it was on my kubuntu box

hello guys
'\xC4\x8Dunal...' for column 'categories_name' at row 1

locate my.cnf

at inserting something nonenglish into varchar/text

sorrty the aaroncampbell. I run kubuntu too

did that...nothing
even updatedb && locate...

do you have mysqld installed?

yes
and functioning fine...and I can use it from all my sites as well as the command line

on this computer it's in /etc/my.cnf
this computer is FC5 i think

mysql -uroot -p -Dezd DataOne_IDP_20070605110517.sql

cat ~/.my.cnf ???

I added it to that, and restarted mysqld, but it made no difference

it seems to not make it by default.. there are examples in: /usr/share/doc/mysql-server-*

Is there any way to force mysql to use a different .cnf file? And if so, can you find out where it is looking?

copy one of the examples from /usr/share/doc/mysql-server* to /etc/my.cnf

there is nothing there...and a locate *mysql-server* gave nothing
hmm, adding a -i to the locate gave me something for mysql-server

doesn't seem like you have it installed then
rpm -qa |grep mysql

It's installed, but not as an RPM. I needed support for UDFs, and that wasn't in the rpm. My server company built it from source

ohhhh
well can't really help you there.. the sources probably have a my.cnf in them, downlaod sources, find file, put it in /etc/

hello
so i got this error when trying to read only some of the tables in my database. it says this tsable was made with a different version of mysql blah blah, whats a workaround, i NEED those tables

hello

KaozGuest, see upgrading notes/ or mysqldump from correct version and import

i want to enable replication on mysql, but when i configure log-bin on the master, then i can't start it !

I made a my.cnf in /etc/ and just added the two lines it needed...seems to have worked. Thanks

and i don't know why, could you help me please
log-bin = /var/log/mysql/tarzan.log
i have put this

excuse my ignorance archivist but i dont understand

i have create the /var/log/mysql directory and chown mysql:mysql

hello any1 have any idea how can i do this
Got error: 1044: Access denied for user 'galbijim'@'localhost' to database 'galbijim' when using LOCK TABLES
i mean this is an error
but how to dump all databases..
any one ?

err.. try granting lock on galbijim
or rather lock_tables

hmmm, i can do it if iam root ?

that is if your only having trouble with locks and not with other functions such as select, alter

root as mysql user

yeah

but when i move the DB it changes form..

move the DB?

dump i mean
i have a backup script that does that for me..

how does it change?

actually its a media_wiki db

i have no idea i never played with wiki's

ok is there a simple way to dump the structure n data separatly ?

but you should have no trouble dumping a DB and putting it back. as long as your not dumping from a higher version of mysql to a lower one
the best bet would be to jsut use SQLyog, and use the copy database function in there.. an amazing time saver!
www.webyog.com

aite, let me check..

brb
bk

Bittarman i am debian
i have downloaded the linux version..
i ran this
./sja exportjob-alltables.xml
a lill help ??
dese are all xml files

errr... sorry
cant really help you thre
*there
have you tried jsut using mysql-dump??

yes..
the error i pasted
Got error: 1044: Access denied for user 'galbijim'@'localhost' to database 'galbijim' when using LOCK TABLES

yer.. login to mysql as root and grant LOCK_TABLES on galbijim@localhost
or run mysql-dump as root

threnody?
are you there?

let me try

Hola

hola :d

Bittarman i managed to dump the db its 71MB .sql file

I have a table that contains the ordering information (as in, 1st, 2nd, 3rd etc) for data in another table, is there some way to do ORDER BY id=(SELECT id FROM other_table ORDER BY ordering) ?

how do i dump it directly from the mysql-dump to the new server

http://www.karkomaonline.com/article.php?story=2004012416185184 i have found thiw howto for replication, but this is only in one way! how to resynchronise the slave on the master when it restart?
i have heartbeat running allready for

assuming you're doing what I think you
at that point, the slave becomes the master, and the master a slave
so it's the same one-way replication just the nodes switched round
you can wait for it to replicate, take down the (now) master, which will switch the slave back to master and then bring up the slave again as a slave
if you want to go back

yes, but when the master come back i want it "remasterise it" (sorry for english)
so, have config like the howto, i have nothing to do?
i try, i stop the slave

oooh technical stuff

it must send new entry to the master which i restart so

when your done davey, could you give me the lowdown on how replication works??

I only know what I pick up in passing from my sysadmin

damn it!

no worries

just found a slave that lacks more than a year behind (master dead)

ok you lot.. how does loadbalancing across mysql servers work? and how do they keep their data synced?

one way is a master server with several read only slaves
all writes have to go to the master, the slaves execute all statements executed on the master (or only some that match certain criteria) so the data is in sync
you can also use multiple masters, which is difficult because of stuff like auto_increment (can be handled with special settings) and you have to chain the servers

we're going with a master-master setup for write servers, and then local webserver mysql read-only nodes

bloody hell.. sounds like loads of fun...

this is why I have a sysadmin

well as the company i workfor is only ickle.. im the sysadmin, developer, and IT support

how can i import the DB from sql file ?

fortunatly i havnt had to do anything major like that yet, thought i would like to get there

in Command line mode ??

I wasn't finished
you can also use mysql cluster
(the phone rang and I had to make it stop ringing)
mysql cluster seperates storage from sql nodes, you can have a bunch of servers store the data (even only parts of the data on storage nodes) and another bunch for sql, the sql nodes fetch the data from the storage nodes then
load balancing can be done via hard/software loadbalancer or in your application

ahh.. more fun
i have done clustering with windows servers before.. but only for file storage.. in my last job
that was a bit of a headache

heya all

nick.. http://dev.mysql.com/doc/refman/5.1/en/batch-commands.html
hello mrdini

hmm, is it possible to retrieve several rows that matches a few codes separated by a space or comma... i.e. WHERE state = "AZ, CA, CT...."

Davey / nils_ how are you implementing master-master without MySQL Cluster?

svn-: yes

re, hmm ok, so it isn't possible to have with two computer for my test, a master/slave and master/slave, which replicate together and when on fall down ... switch ...

svn-: with 2 servers: Server 1: Slave of Server 2. Server 2: slave of Server 1
svn-: so write statements on server 1 get replicated to server 2 and vice cersa. more complicated with more hosts.
thinking of split brains...

what happens when you have loss of connection? Isn't the replication "real-time" so anything replicated during a data link failure will not get replicated to the slave(s)?

i want to do that nils_
but i have try, i have enable log-bin on both, and put the ip of the other in my.conf

svn-: everything that is committed is replicated.

but, master (1) write to 2

1

server id has to be set and a bunch of other things, auto increment offsets and so on, did you read the multi master part in my.cnf?

"IN"

:/

svn-: replication is not realtime, it can be delayed.

i have no see it
have not
i search multi master ?

didn't mean my.cnf, I wanted to talk about the docs
check the documentation

I am currently using MySQL Cluster in a dual master setup

could you give me on howto please nils_

the problem is, it is very traffic intensive

hmm mysql docs don't tell much about it, there was an article somewhere...

though I suspect replication will be equally intensive on bandwidth

please please find it me
not a problem for me, this is for demonstration and then with gigabyte now?

http://dev.mysql.com/books/hpmysql-excerpts/ch07.html

1Gb eternet card

svn-: that depends, as replication is statement wise.
svn-: in mysql 5.1
svn-: in mysql cluster the actual data is transferred, which is more for large write statements (single update statement can affect many, many rows)
svn-: problem with replication is that it isn't real-time...
most you need to know about replication in that link.

thanks nils_

interesting question... I need to set a permission so that any user authenticated with their password is allowed on localhost and 192.168.10.x

most of the rest is learned from painful experiences

to the mysql server, that is

I am syncing over the Internet, which is a bit daft

well the problem is, that % doesn't apply to unix domain sockets...

grant twice then

NDB is utilising 99% of the bandwidth

hmm

so you get user@localhost

svn-: yeah, replication might be better.

then do user@ip

I'm in phpmyadmin, and I have Any % -- USAGE NO

ask your local phpmyadmin expert or use the mysql console

I will look into that. But replication will inevitably lead to a master / slave setup for my application, which needs real-time syncing in its current state

svn-: multi master is no option?
svn-: what kind of application?

the data needs to be in sync all the time for both reads and writes

ok

nasty nda, sorry. can't go into specifics

mysql cluster or single large box

yep
or master / cold slave + heartbeat + replication

yeah well that's something I'd consider in the range of single large box, you'll need a large box to fall back to

how do i set all coallitions in a database, inlcuding tables and columns to a certain coallition?
now i have to do it one and one

keeps you warm
no single sql command for that, write a script...

nils_, darn.. well well

svn-: with cold slave, always monitor Seconds_behind_master, that's what I learned today
damn power supplies these days.

hm, I'll make a note to myself about that

yeah

with single large box I would lose the redundant power / other upstream etc so that was no go

just sort of failed over today, looked in the admin tool "oops? No sales for this month? And last month?"

ouch

does mysql support permissions on a table level?

yep.

how far down does the permission checking go?

I think table level is max

ok, thanks

hey, could you pastebin me only the needed for master - master, i'm not english and there are too much information, my blind is full

Related Topic: