Hi All,
I have take a mysqldump of my entire database, is it possible to restore
just one table from this mysqldump.
Also, i have taken binary backup of my database, and one of the datafile is
corrupt, is it possible to restore just this file from backup and start the
mysqldb. Mysql database is r
Sorry if this was already posted, but I don't recall seeing it, and I read the
list every day.
I also checked here: http://lists.mysql.com/mysql and didn't see any mention.
This makes me a little concerned. Why aren't these security issues being posted
to the list? This is at least the third on
DB the server won't respond immediately
causing the conenct to time-out..
Does your script start with an information_schema query? The frist one
of those is painfully slow with MySQL.
Did you try set_time_limit( 0 )?
PB
-
JM wrote:
after trying it again ang again.. maybe for the 5th t
Hi JM -
Can you send us a few things?
1 - the exact error message you get
2 - the output of "SHOW VARIABLES;" from a mysql session
3 - the output of "SHOW STATUS;" from a mysql session
What have you tried so far in terms of troubleshooting that has been
unsuccessful?
Any recent changes on the
after trying it again ang again.. maybe for the 5th time.. PHP will now be
able to connect..
On Monday 14 May 2007 22:34, JM wrote:
> Hi,
>
> Im using MySQL-5.0.19-0 and for some reason when ever PHP connects to
> the
> DB the server won't respond immediately causing the conenct to time-o
Are you running on Windows? I seem to recall that you can't normally
schedule a task unless the user has a password. That might apply only to XP
Pro, I don't know about the server versions of Windows.
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farm
On Mon, May 14, 2007 17:56, John Meyer wrote:
> Mike Blezien wrote:
>> Hello,
>> - Original Message - From: "John Meyer" <[EMAIL PROTECTED]>
>> To: "MySQL General"
>> Sent: Monday, May 14, 2007 10:26 AM
>> Subject: Re: Scheduled backups
>>
>>
>>> J Trahair wrote:
Hi Everyone
>>>
Mike Blezien wrote:
> Hello,
> - Original Message - From: "John Meyer" <[EMAIL PROTECTED]>
> To: "MySQL General"
> Sent: Monday, May 14, 2007 10:26 AM
> Subject: Re: Scheduled backups
>
>
>> J Trahair wrote:
>>> Hi Everyone
>>>
>>> I have set up a scheduled backup using MySQL Administrator
Hello,
- Original Message -
From: "John Meyer" <[EMAIL PROTECTED]>
To: "MySQL General"
Sent: Monday, May 14, 2007 10:26 AM
Subject: Re: Scheduled backups
J Trahair wrote:
Hi Everyone
I have set up a scheduled backup using MySQL Administrator. Stored
connection, database, dates and
J Trahair wrote:
> Hi Everyone
>
> I have set up a scheduled backup using MySQL Administrator. Stored
> connection, database, dates and time, even the Windows user password (in
> fact, blank). It doesn't start at the correct time, or indeed any time.
>
> Have I missed something?
>
> Thanks for yo
hi,
here is my backup bat file for backup of innodb:
set MYSQL_HOME=C:\Program Files\MySQL\MySQL Server 5.0
set BACKUP_FILE=mysql5-db-backup-xp_%DATE%.sql
del "BACKUP_FILE"
"%MYSQL_HOME%\bin\mysqldump" --user=xxx --password=xxx --skip-opt
--single-transaction --quick --add-drop-table --default-c
Hi Everyone
I have set up a scheduled backup using MySQL Administrator. Stored connection,
database, dates and time, even the Windows user password (in fact, blank). It
doesn't start at the correct time, or indeed any time.
Have I missed something?
Thanks for your help.
Jonathan Trahair
Ian P. Christian wrote:
> richard wrote:
>
>> as far as I can see, these commands select which db's to replicate on
>> the slave that currently exist on the master server.
>> What i am asking is, if I set a server up as a slave, can I have other
>> databases on the slave that are not part of the
Hi,
Im using MySQL-5.0.19-0 and for some reason when ever PHP connects to
the DB
the server won't respond immediately causing the conenct to time-out.. No
firewall issues and no network related issues. The only thing that I noticed
is that the server's average load is 60%.
Thanks,
Hello
Sorry to ask a question already posted, but answers appear not clear and
I do not find any information in the documentation.
There is a patch for IPv6 at http://www.ngn.euro6ix.org/IPv6/mysql/
for the 4.0.18 version.
Does anyone use this patch with success in her/his company ?
Does a
richard wrote:
> as far as I can see, these commands select which db's to replicate on
> the slave that currently exist on the master server.
> What i am asking is, if I set a server up as a slave, can I have other
> databases on the slave that are not part of the replication system?
Yes - I've be
techincally yes you can have. replication is all about the queries that are
getting executed on the master will be executed on the slave. So , if the
database that exists on the master exists on the slave , then you should
have no problems.
Thanks
Alex
On 5/14/07, richard <[EMAIL PROTECTED]> wro
as far as I can see, these commands select which db's to replicate on
the slave that currently exist on the master server.
What i am asking is, if I set a server up as a slave, can I have other
databases on the slave that are not part of the replication system?
MySQL 中文网 wrote:
>
> of course
>
Hi,
I have a server (master version 4.0.1) that has a database that I want
to replicate on another server (slave version 4.1.20).
The slave already has another db on it. Is is possible to have a mixture
of replicated and non replicated dbs running on a slave?
cheers
Rich
--
MySQL General M
On Monday 14 May 2007 09:07:43 [EMAIL PROTECTED] wrote:
> To confirm that you would like
>
> [EMAIL PROTECTED]
>
> removed from the mysql mailing list, please click on
> the following link:
>
> http://lists.mysql.com/u/mysql/46480abf72dbdd5d/sklorz=gmx.de
>
> This confirmation serves two purpos
20 matches
Mail list logo
