Hi Patrick,
The error says a permissions problem. Did you change the ownership/group
to mysql:mysql, to the mentioned files, after you restored them?
Regards
---
** _/ ** David Logan
*** _/ ***
Hey all,
I host my app on a friend server who make backup every night, well
yesterday he installed another distro so I asked him for my db backup
and it turns out the only backup he did was the whole hard drive. So
he just sent me a tarball of my database directory containing:
ads_categories.MYD,
Marten Lehmann wrote:
that is the sort of thing that I expected and was afraid of. Also, I
think the mysql documentation doesn't really point out that temporary
tables are always kept in memory. Couldn't mysql create them in
/tmp/. instead?
Actually I was just reading through the docs about thi
Hello,
> If a person forgets to drop temp tables and stays within a connection
for hours or even days, memory resources can be overloaded a lot of temp tables.
Furthermore, loading temp tables with a GB of data is bad practice but is
possible
under such circumstances.
that is the sort of thin
Interesting question - I too noticed that in the comments. For what
it's worth, I used it in production environment for more than 5 years
with no problems, from 2001 on. I did restore a few things here and
there, so I know it was working! ;)
I use mysqldump for backups now because we use InnoD
Is mysqlhotcopy still considered "beta"? We steered clear of it for
production use for that reason.
Tim
-Original Message-
From: Dan Buettner [mailto:[EMAIL PROTECTED]
Sent: Monday, November 13, 2006 12:39 PM
To: Van
Cc: mysql@lists.mysql.com
Subject: Re: Backing up large dbs with tar
I've use MS Visio's "Reverse Engineer" database feature to find the FK
relationships between tables. I'd bet there are other tools which do
something similar, probably even free ones.
Tim
_
From: Peter Brawley [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 14, 2006 2:36 PM
To:
Clyde,
>How can I find the foreign keys for a table?
At http://www.artfulsoftware.com/mysql-queries.php in the left pane
click on DDL then on 'Find parent tables'. HTH.
PB
-
Hello,
How can I find the foreign keys for a table? I would like to be able
to find, for any table, the
Alternatively you can use:
SHOW TABLE STATUS from name_db like '%part_of_table_name%';
to get a list of all fk constraints in the database that match
a certain string. It also gives some other interesting information.
As far as dependencies go you can see which table the constraint
references
Will the output from the show command also provide a list of other
dependent tables? From what I've seen with the "show create table
" command, it only provide keys associated with that table
, but other dependent tables.
Thanks so much.
At 01:18 PM 11/14/2006, Howard Hart wrote:
show creat
Hello,
How can I find the foreign keys for a table? I would like to be able
to find, for any table, the columns that are foreign keys and what
tables/columns the foreign keys are related to. Basically what I am
trying to do is this. My developers want to allow logical deletes of
data. I don't wan
>From what I know, your solution would only work if you have exactly three
records to find (there might be 1 or 100), only if the latest records fall
within the last three days. I think Vittorio said he didn't know ahead of
time what most recent date would be.
Regards,
Jerry Schwartz
Global Infor
Assuming that insertdate is a DATE column,
SELECT * FROM t
WHERE t.insertdate = (SELECT MAX(t.insertdate) FROM t));
would do it.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
> -Original Message-
> F
If you're looking for the records from the last full day contained in
the data, not the past 24 hours according to the clock, then this
ought to work:
select * from table
where InsertDate >= date_sub( (select max(InsertDate from table),interval 1 day)
order by InserDate desc
Dan
On 11/14/06, V
select * from table where InsertDate = date_sub(now,interval 1 day) limit 3;
Not tested, but i think it will work fine.
""Vittorio Zuccalà "" <[EMAIL PROTECTED]> escreveu na
mensagem news:[EMAIL PROTECTED]
> Hello,
> i've a table with a lot of field and in particular:
> "InsertDate","Box","Prt"
Leandro Guimarães Faria Corcete DUTRA wrote:
On Wed, 08 Nov 2006 18:51:20 -0800, Rares Vernica wrote:
Is it possible to access the Full-Text Index structures from SQL?
What do you mean exactly? SQL is not intended for physical structures.
I started writing a little
I have a table (example 1):
tblRegulations
fldCountryID (int)
fldRegualtionType (int)
fldRegulationUpdated (date)
fldRegulation (text)
Each country can have up to 7 different regulation types. I have
designed the table like this so I can have one fulltext index on
fldRegulation, and thus search
Hello,
if there are not any security impacts, why does the
Create_tmp_table-privilege exist separately to the
create_table-privilege? Or if it has security impacts (maybe
automatically granting other rights), which ones?
The mysql documentation doesn't tell much about this.
Regards
Marten
As I mentioned before, you could use 'myisam_ftdump' to see the contents
and word distribution of a MyISAM table's fulltext indexes. If you are
very bold with source code, download the MySQL Source Code and lookup
how fulltext indexes are populated.
You should be able to find that section of the c
Maybe it is because you can manually create temporary tables in Stored
Procedures.
Creating tables using 'create_priv' allows other users to view your table if
the other users have 'select_priv' for that same table.
Creating tables using 'create_tmp_table_priv' allows only the calling user
to vi
Hello,
i've a table with a lot of field and in particular: "InsertDate","Box","Prt"
Example:
InsertDate, Box, PRT
2006-11-01, BXT, 34
2006-11-01, TTS, 33
2006-11-01, RRT, 55
2006-11-02, BXT, 22
2006-11-02, TTS, 99
2006-11-02, SAR, 75
I'd like to find all record inserted in the last day...
In thi
21 matches
Mail list logo