| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Comments:
<0> because the fs is better at distributing blobs?
<0> isnt the db's files blobs themselves?
<1> Akuma_: np
<2> epic: true, storing binary objects is just not what a database is meant for, hence the name database..;)
<3> I ran ./configure on 4.0 with --program-suffix=40, and now mysql_install_db40 is looking for mysqld and not mysqld40. Is there a way to make this work properly?
<3> ahhh man this install script has not been changed to ./configure options
<4> hepp!
<5> kombi_: If you have data that is accessed by month and day, there are several ways to structure your tables. One simple way is to create a user_data table with primary key [user_id, month_id, day_id] and any other column(s) to hold the data you wish to store. To fetch the data: SELECT * FROM user_data WHERE user_id=10 AND month_id=month(now()) AND day_id=dayofmonth(now());
<5> kombi_: There are some fundamental principles when using relational databases you were violating in your previous attempt.
<2> Xgc: sorry, I was away for a while. You are absolutely right, it is actually not my design..
<5> kombi_: Further, the SQL language requires that you use a table name (not a derived name) in the FROM list. The only way around that is to use something like a VIEW or to use a dynamically generated statement.
<5> kombi_: "table name or derived table", not a derived name.
<2> Xgc: point taken, actually solved the issue some time ago
<6> hi all
<2> thanks though!
<6> i have a problem with myodbc
<5> How did you decide to address this?
<6> when i hit Test button on it, it bugs
<6> why?
<5> The question was to kombi_.
<2> Xgc: working on other peoples code..
<2> Xgc: oh, you mean how did I work my way through it? Fiddled a little with the host app..
<5> ik0o0o: You'll need to be more specific.
<6> well
<6> i install the connector
<6> then a goto to data sources in the control panel
<6> add the data source
<7> Darien?
<6> and then when i change options in it
<6> and hit the Test button it bugs
<5> ik0o0o: Type full thoughts on one line.
<5> ik0o0o: That's still very incomplete.
<5> ik0o0o: "I did stuff and it didn't work" isn't enough information.
<5> ik0o0o: Does this have something to do with MySQL, other than MySQL is the target of your connection attempt?
<5> ik0o0o: If MySQL is only the target, what error do you see that indicates to you this is a MySQL issue?
<5> ik0o0o: Did you even see an error at all?
<5> ik0o0o: Do you think it would be helpful to show the *exact* error you saw?
<6> no
<6> it shows that the connection is successful
<6> and afterwhile it bugs
<5> ik0o0o: it?
<6> the myodbc dialog
<8> mysqldump -u user -pp*** databasename > mar042006.sql
<8> hey, how do I modify this so that only one table from 'databasename' gets exported?
<5> ik0o0o: Post a bug report to the bug tracking system, after making sure it's a new bug and should be posted.
<6> Xgc how to make sure?
<8> no easy way to export just one table instead of whole database?
<5> ik0o0o: 1) Recheck to be sure you installed properly, following all system requiresm, etc. 2) You won't want to post a duplicate report. Attempt to find an existing similar bug report. If you don't find one, post a new report.
<9> hello
<5> Sorry... *requirements*
<9> Is it possible to change backup of mysql v4.1.14 to 4.0.25 ?
<5> [M4rk0]: What do you mean by that?
<9> i have done backup of my databes @ cpanel where is mysql 4.1.14... i can't now install backup to another server with mysql v4.0.25
<8> hm
<5> [M4rk0]: Look into mysqldump options that allow compatibility with older versions. See: --compatible=name
<10> [M4rk0]: mysqldump has --compatible flag where you can take your backup in a "mysql40" compatible mode
<8> gotit
<9> but how from cpanel i don't have shell access
<9> i mean phpmyadmin
<11> that has a compat mode
<9> can i somehow change my database backup from my own linux machine than import it on my web server?
<9> ?
<2> why change it?
<2> should work as is..
<9> it doesn't work :)
<9> umm :(
<2> how do you back up?
<9> i made
<9> whole cpanel backup
<9> and there is also mysql backup...
<2> do mysqldump
<8> how do I kill a query?
<12> when i insert this ----CREATE TABLE logs (id int(10) DEFAULT '0' NOT NULL auto_increment, timestamp varchar(16), host varchar(255), prog varchar(255), mesg text, PRIMARY KEY (id)); --- I get this error ERROR 1067 (42000) at line 7: Invalid default value for 'id'
<12> what is wront with that insert?
<12> wrong*
<2> try without the quotes
<12> MySQL said: Documentation
<12> #1067 - Invalid default value for 'id'
<12> still same error
<13> hi there
<13> I miss a MYD file but MYI and frm are still available
<13> can I recreate my MYD file somehow?
<2> drache: that is quite impossible..
<5> Tony|Home: Remove the default completely.
<13> kombi_: can I use the frm table definition to get an empty MYD file or something like that?
<12> Your SQL query has been executed successfully (Query took 0.0139 sec)
<12> :)
<13> the structure can also be helpful in this content
<12> Xgc: why was it not taking default '0'?
<2> drache: I'm afraid not..
<13> can I read out the table definition from the frm file?
<13> martin ebay # file Artikel.frm
<13> Artikel.frm: MySQL table definition file Version 7
<13> can I use that somehow?
<5> Tony|Home: There's no reason to have a default for a auto_increment column.
<12> hmm interesting.
<5> Tony|Home: So MySQL offers no support for that.
<9> Xgc, TodoInT1, kombi_: http://img486.imageshack.us/img486/5474/mysql2ri.jpg <- same error when i try mysqldump...
<5> [M4rk0]: Be more specific. "try" doesn't tell us enough.
<12> Xgc: thx for the help :)
<4> not with the lost contents
<4> MYD stores the data part while MYI stores the index and frm stores the definition of the table
<5> [M4rk0]: If you asked some util XYZ to create a 4.0 compatible file and it didn't, report it as a bug.
<9> mysqldump --compatible=mysql40 mostarac_mostar.sql
<9> doesn't help
<9> same error as phpmyadmin show
<5> [M4rk0]: That's not correct.
<5> [M4rk0]: Don't retype. Copy / paste so that we know the exact statement you used.
<9> mysqldump --compatible=mysql40 mostarac_mostar.sql -pMY-ROOT-P***WORD
<5> [M4rk0]: Look at the date/time stamp on that sql file.
<9> what do you mean
<5> [M4rk0]: ls -l
<9> 2006-03-04 19:45
<9> my time 19:48
<5> [M4rk0]: Sorry. That's very unlikely.
<9> What should I do?
<5> mysqldump --help
<13> isn't there any way to get out the structure of an frm file? what create statement it holds?
<5> [M4rk0]: That database probably doesn't exist.
<9> hm what do you mean? there is .sql file with ~7MB
<5> [M4rk0]: mostarac_mostar.sql is your database name??
<9> it my database backup file
<5> [M4rk0]: No. It isn't.
<9> you are confusing me
<5> [M4rk0]: Then why did you provide mostarac_mostar.sql as the database name in the command to mysqldump.
<9> because i can't import in my database this mostarac_mostar.sql backup file
<5> [M4rk0]: The general form is: mysqldump ... dbname tablename -- the output would go to stdout.
<5> [M4rk0]: To output to a file, you'd redirect stdout in some way. The command you showed was completely wrong.
<9> but i want to convert file to older database?
<5> [M4rk0]: mysqldump doesn't convert one file to another.
<9> haha, then what should i do? delete backup?
<5> [M4rk0]: It dumps data from your database to a file in a specified form.
<9> i understand now what mysqldump do
<14> I'm trying to start mysql and its giving me a sock error anyone able to shed some light on this?
<5> [M4rk0]: You need to make a compatible backup file or hand edit the existing file to be compatible.
<15> My Program needs to check wetter the database/tables are in place. I used create if not exist... But other RDBMS do not always support that. If I just create the tables every time the program starts, it will also give an error. How do you guys do this?
<9> and i don't need that. i don't have anymore database as active only as backup file... :(
<5> [M4rk0]: That's a problem.
<9> yeah :(
<5> [M4rk0]: Install 4.1 locally. Import the current backup. Then dump it in a form compatible with 4.0.
<9> ok
<9> thank you on your time
<5> [M4rk0]: MySQL installs easily on a laptop.
<16> anyone know of a nice way to swap two rows? Would it be pretty required to use a 'weight' or 'index' column to do the swapping of two items on (for manual sorting of individual items)?
<5> You're welcome.
<5> Xedecimal: You don't worry about physical order. You use SQL to order result sets properly.
<17> I've got a table called 'item_type_mapping' with the columns item_type_mapping_id, item_type_id, field_name, field_value I also have a table called 'item_type' with the columns item_type_id, item_type_name. I'm trying to do a return a query that looks like item_type_id = '1', and list of all the field_name, field_value since there are many? But I get duplicates
<16> what if someone wants to move an item down a list?
<17> Should I be using a join or something
<5> Xedecimal: SELECT ... ORDER BY ...;
<5> Xedecimal: No such thing. ORDER is determined by the data. You change the design to provide this orderable data.
Return to
#mysql
or
Go to some related
logs:
#debian
cropdetect bash
#gentoo
udev run-program exec of program failed
ubuntu cannot ping
#ubuntu
#web
xintruder'a
#php
#math
|
|
