Re: ssh basics

that ssh is the better solution, even if a bit more work to setup, sometimes. -Thufir -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: ssh basics

st mysql] will log in to your machine and start the > mysql client. The -t tells SSH to allocate a pseudoterminal even though > you specified a command to run. Now, that sounds like a plan! -thufir -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: ssh basics

just using mysqldump, but will probably need some additional tools to use. I can't really foresee much admin, many scripts to run against the db, but I suppose there's always something. Yes, I'm still figuring out the mechanics of ssh. It was more of a ssh question than a MySQL

Re: ssh basics

On Sun, 08 Mar 2015 08:43:41 -0400, Ruben Safir wrote: > gmail sucks You prefer yahoo mail? Just curious. -Thufir -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: ssh basics

On Sun, 08 Mar 2015 13:41:32 +0100, Reindl Harald wrote: >> What's the advantage? > > that you can have a local application using mysql by -h 127.0.0.1 which > is a complete different thing than a interactive shell? Thank you for explaining that. -Thufir -- MySQL Gene

Re: ssh basics

On Sun, 08 Mar 2015 10:47:17 +0100, Reindl Harald wrote: > oh my god... https://www.google.at/search?q=ssh+tunnel hmm, are you thinking that I'm not using ssh? Because I'm using ssh currently, and it works fine. How is ssh -L 3305:localhost:3306 thufir@192.168.1.

Re: Remote Access to MySQL

ed, anyhow?) I would start with granting all to a specific user, make sure to use the %, which, I think, allows remote connections. HTH, Thufir -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: ssh basics

On Sun, 08 Mar 2015 01:30:46 +0100, Reindl Harald wrote: > Am 08.03.2015 um 01:20 schrieb Thufir: >> I want to ssh into Mysql, something like: >> >> thufir@doge:~$ >> thufir@doge:~$ ssh -L 3306:localhost:3306 thufir@192.168.1.3 bind: >> Address already in use &g

Re: ssh basics

On Sun, 08 Mar 2015 00:20:26 +, Thufir wrote: > I mean, I can ssh into tleilax and then fire up the MySQL console. Is > there a better approach? > This just hangs: thufir@doge:~$ thufir@doge:~$ mysql -u cron -h 192.168.1.3 -p Enter password: ^C thufir@doge:~$ because, I

ssh basics

I want to ssh into Mysql, something like: thufir@doge:~$ thufir@doge:~$ ssh -L 3306:localhost:3306 thufir@192.168.1.3 bind: Address already in use Last login: Sat Mar 7 19:18:20 2015 from 192.168.1.2 Thank you for installing ViciBox Server v.6.0! This software is available for free download at

Re: forum vs email

ead the messages, then occasionally save an interesting one to a mail > folder or reply and take part to a thread. Someday, in the far, far future, someone will re-invent usenet. Until then, there's gmane! although a surprising number of mailing lists have some sort of mistrust toward

is a .sql file transactional

when you run a .sql file, which modifies a schema, is it transactional? Specifically, is it an all-or-nothing proposition? Or, can some commands get executed, some fail? thanks, Thufir -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

chntpw

x27;m leery about messing up the Windows system, just want to clarify. thanks, Thufir -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: "text" field too small to store html page source?

On Tue, 18 Nov 2014 13:09:25 +, Daniel Rios Couto wrote: > You could try MEDIUMTEXT (16mb) or LONGTEXT (4gb) for a very large > text... > On Tue Nov 18 2014 at 7:39:11 AM Reindl Harald > wrote: > > >> Am 18.11.2014 um 10:48 schrieb thufir: >> > I'

"text" field too small to store html page source?

] [EL Info]: 2014-11-18 01:36:57.574--ServerSession(17148489)-- EclipseLink, version: Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd [java] [EL Info]: connection: 2014-11-18 01:36:58.798--ServerSession (17148489)--file:/home/thufir/NetBeansProjects/AggregatorJpaClient/build/ classes

Re: alter table for foreign key

ULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `UNQ_links_0` (`link`), KEY `fk_links_1_idx` (`feed_id`), CONSTRAINT `fk_links_1` FOREIGN KEY (`feed_id`) REFERENCES `feeds` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=270 DEFAULT CHARSET=latin1 |

Re: alter table for foreign key

On 14-11-17 01:42 AM, thufir wrote: Looking at the docs: http://dev.mysql.com/doc/refman/5.6/en/create-table-foreign-keys.html how do I alter the child table, links, so that it has a foreign key with the parent table, feeds? The workbench GUI came up with: ALTER TABLE `rome_aggregator

alter table for foreign key

| NO | | 0 || +-+--+--+-+-++ 5 rows in set (0.00 sec) mysql> While I know that I should alter the table, I don't know the syntax to establish the foreign key constraint. thanks, Thufir -- MySQL Gen

Re: error 29, file not found (errcode: 13)

I followed the manpage for mysqlimport: thufir@dur:~$ thufir@dur:~$ mysql -e 'CREATE TABLE imptest(id INT, n VARCHAR(30))' test ERROR 1045 (28000): Access denied for user 'thufir'@'localhost' (using password: NO) thufir@dur:~$ thufir@dur:~$ thufir@dur:~$ mysql -

Re: error 29, file not found (errcode: 13)

I think it's apparmor: thufir@dur:/tmp$ thufir@dur:/tmp$ nl /etc/apparmor.d/usr.sbin.mysqld 1 # vim:syntax=apparmor 2 # Last Modified: Tue Jun 19 17:37:30 2007 3 #include 4 /usr/sbin/mysqld { 5#include 6#include 7#include

Re: error 29, file not found (errcode: 13)

On Mon, 23 Jun 2014 10:59:48 -0400, Scott Helms wrote: > I generally drop them into /tmp for easy access and cleanup after the > data load, but you can put them any place that the mysql daemon process > has access to read. Huh, maybe the daemon doesn't have access to /tmp?... t

error 29, file not found (errcode: 13)

Apparently this error is because MySQL can't read my home directory? Fair enough, but I don't quite follow. Where would be a good location for the CSV file, then? thufir@dur:~$ thufir@dur:~$ mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end wi

gmane

case and the list is read-only on gmane. Would it be possible to change that? thanks, Thufir -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

javax.mail.Message

the content be in its own table? thanks, Thufir -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

calculating breaks for an employee

to represent that the break wasn't at the correct time? A metric? I'm thinking that the schedule would be its own table, and then an "events" table to store login/logouts, breaks and meal breaks. Would it make sense for the PK of both tables to be the employee ID numbe

Re: function/procedure error!

On Thu, 06 Mar 2008 08:05:06 -0800, puntapari wrote: > And returning a list of numbers? It can be and how? A bit tangential, but this calculation could be done recursively with ruby. Are you tied to SQL for this? -Thufir -- MySQL General Mailing List For list archives: h

Re: what is a schema? what is a database?

On Wed, 05 Mar 2008 15:01:12 +0100, Joerg Bruehe wrote: > I have not heard of a three level naming scheme yet. Aha, thanks for the history, helps to put what I was reading into context. -Thufir -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscr

Re: how to select total votes for each comment?

On Wed, 05 Mar 2008 09:29:03 +0100, Sebastian Mendel wrote: > SELECT > comments.content, > SUM(votes.votes) > FROM > comments > LEFT JOIN > votes > ON > comments.id = votes.comment_id > GROUP BY > comments.id Interesting :) -T

Re: Debugging mysql limits

it does screw up some queries"! when I asked what the primary key was going to be for the new table(s) he mentioned that when the db was initially designed that they didn't know about primary keys! As if PK's are a fad... -Thufir -- MySQL General Mailing List For list archives

Re: FW: Re: what is a schema? what is a database?

e Sales.Product and > Manufacture.Product. > > A fully qualified SQL Server object name is > server.database.schema.object. In your two examples: SELECT * FROM server.sales.schema.product; SELECT * FROM server.product.schema.product; I'm a bit tired, so maybe I'm not seeing

Re: password for system user

it working for logging into MySQL as the root db admin but can't add the "rails" MySQL user so that user thufir can login to MySQL as "rails" passing the password from /etc/my.cnf (too many pronouns for that to make sense). Some success: [EMAIL PROTECTED] ~ $ [EMAIL PROTE

Re: Using MySQL with its data files on a CD-R (recordable CD)

I would > appreciate any additional info people have to offer. Would this be like an ldap server? -Thufir -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: unnormalize db here is more efficient?

alculation you want. -Thufir -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: what is a schema? what is a database?

t are they getting at? Why would you want to do a query of: SELECT * FROM database.schema.table; Obviously, this is non-sense in MySQL, where database <==> schema. -Thufir -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

password for system user

I understand that there's a configuration so that instead of typing: [EMAIL PROTECTED] ~ $ mysql -u root -ppassword that the password (of "password") is stored so that whenever this user connects as root the password is automatically passed. Is this possible? thanks, Thu

Re: Debugging mysql limits

st. May I ask why you have fifty plus tables with, apparently, the same schema? Why not have one table with an extra column "user"? -Thufir -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: what is a schema? what is a database?

, this is how MySQL does it and is how I've been doing it. Some databases do it differently, apparently. Apparently MySQL lacks this feature, but what feature is it lacking? There's no equivalent to: SELECT * FROM database.schema.table; thanks, Thufir -- MySQL

what is a schema? what is a database?

e_management_systems#Databases_vs_Schemas_.28terminology.29 thanks, Thufir -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

left/right join concept

o add or correct, please? thanks, Thufir -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

recursion

Destination FROM FLIGHT ) SELECT * FROM ReachableFrom WHERE Source = "Portland"; thanks, Thufir -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Certified MySQL Associate (CMA) certification value

l.com/certification/ it wouldn't make sense in a cost/benefit analysis. Just curious what others think of this program. -Thufir -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: can't import

7;t tell you. > > It has nothing to do with the mysql password or the spaces in the file. I changed the SQL syntax, but will test it further as I'm getting back into MySQL :) -Thufir -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscri

Re: Certified MySQL Associate (CMA) certification value

u could hardly > go wrong with it, IMO. [...] Yeah, I think that I'm going for the certification, although I can't imagine what kind of job I could land -- junior DB admin? I don't have a college degree :( -Thufir -- MySQL General Mailing List For list archives: http:

Certified MySQL Associate (CMA) certification value

I was wondering was: what's the value of this certification for me? What doors will it open? thanks, Thufir -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

SQL LINKING TABLE Command

fields. <http://www.plus2net.com/sql_tutorial/sql_linking_table.php> how is this different/better than a many-to-many, such as <http://www.plus2net.com/sql_tutorial/sql_inner_join.php>? Isn't that a better way of doing the same thing? Or, not? thanks, Thufir -- MySQL General

one-to-one relation, foreign key creation

I want contacts to have a 1-1 relation to px_items. I'm hesitant to add the contact info onto px_items because uses that table. from phpMyAdmin, how would I re-organize things pls? Or, must I manually enter the SQL to establish the foreign key part? Once I have

rss2email

I'll be using for saving rss info. Just curious as to how others would do this, to avoid data entry. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: import rss feed into mysql

Ryan Stille cfwebtools.com> writes: > > Perl would be my language of choice to do something like this. > > -Ryan what about <http://paperboy.sourceforge.net/>? thanks, Thufir -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

import rss feed into mysql

what would be the quickest, easiest way to import, for example, the rss feed <http://rss.gmane.org/gmane.comp.db.mysql.general> into mysql? what would be some different approaches, pls? I'm more interested in craigslist stuff, but the above is a good example, I think. than

Re: can't import

the ownership of the data file? or that I took out some spaces on the data file? Or, ... ? -Thufir -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: can't import

logout [EMAIL PROTECTED] ~]$ [EMAIL PROTECTED] ~]$ cat /tmp/abc.txt -n 1 A1, B1, C1 2 A2, B2, C2 3 A3, B3, C3 [EMAIL PROTECTED] ~]$ [EMAIL PROTECTED] ~]$ cat /tmp/abc.txt A1, B1, C1 A2, B2, C2 A3, B3, C3 [EMAIL PROTECTED] ~]$ [EMAIL PROTECTED] ~]$ [EMAIL PROTECTED] ~]$ [EMAIL PR

can't import

I'm at total loss. apparently, error 13 relates to file permissions? what could possibly be preventing the import? <http://paste.husk.org/8073> for: [EMAIL PROTECTED] ~]$ [EMAIL PROTECTED] ~]$ ll /tmp/abc.txt -rw-r--r-- 1 thufir thufir 33 Apr 12 06:59 /tmp/abc.txt [EMAIL PROTECT

import fails: error 13

---+---+ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-+---+ | a | text | NO | | | | | b | text | NO | | | | | c | text | NO | | | | +---+--+--+-+-+---+ 3 rows in se

RSS import

I'd like to import an RSS feed into mysql using <http://paperboy.sourceforge.net/ > and was curious as to whether others have done similarly. thanks, Thufir -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql

general info relating to proprietary db

his is the scenario. I'm just curious as to what could cause such a situation. -Thufir -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

data entry GUI

t it seems to be either that or mysql> insert into A (one, two, three) values (1 , 2, 3); Either option seems a bit much. Perhaps there's something akin to Access's form builder? -Thufir -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

mysql-query-browser install RPM

[EMAIL PROTECTED] ~]$ ll /opt/ total 0 [EMAIL PROTECTED] ~]$ mysql -u thufir -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 13 to server version: 4.1.16 Type 'help;' or '\h' for help. Type '\c' to clear the buff

Re: password? getting started

ther reason the database is "stopped" it must be restarted? Hmm. And there are different levels of users for the database, apparently. Bit of adjustment required! -Thufir -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: password? getting started

id is 3 to server version: 4.1.16 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> quit Bye [EMAIL PROTECTED] ~]# date Wed Feb 1 03:48:43 EST 2006 [EMAIL PROTECTED] ~]# heh. Now I just have to figure out how to do stuff! :) -Thufir -- M

password? getting started

s? RTFM, I know, I'm going to the library first chance I can. -Thufir -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]