Better yet, either do a "cp -a" (if GNU cp) or "mv", then modify your
my.cnf to reflect the new location. Your file permissions and ownership
will have been preserved if you used either of these commands, and it's
good to go.
On Mon, 2008-08-18 at 11:59 +0530, Ananda Kumar wrote:
> Shut down mysq
Hi Dan,
I cannot speak for EMS or SQLyog, but certainly with the MySQL
Administrator you create the backup files on your client PC (the PC
running the tool) and then when you restore it, you select the file from
your local PC and it sends the SQL commands required to restore the
database to t
Hello,
Couple of questions - experienced MSSQL developer but new to mySQL.
I have 2 servers on a local network. I did a dump from one to its
local drive, and I want to restore it to the 2nd server.
1. is it possible to do this with 3rd party tools such as SQLyog or
EMS Sql Manager? When I try to
Regardless of who has implemented the network and the status of
provided monitoring tools, this has all the look and feel of
intermittent network issues. I would run an independant network scan
(maybe nmap?) from one of the affected clients to the affected host
and I bet you will find that the sa
HI Pieter
I have a suggestion.this might not be very helpful
Try to reconfigure the connections between the client and Mysql
server where the problem exists.and then try to notice the
uptime and logs of the server.
CHAVA
On Mon, Aug 18, 2008 at 12:00 PM, Piet
Greetings to all,
I am having a weird issue with MySQL that I can't solve. We are getting
intermittent client connection errors code 2003 to the database server for
10mins seemingly at random, and after 20+ days of uptime. Unfortunately, I
have not been able to correlate these connection problems
If you are desperate, you can also start mysqld with --skip-grant-tables
option.
Then use mysql, update root password using the update statement that Jim
wrote about.
-Paul
On Mon, 2008-08-18 at 17:25 +0100, Andy Shellam wrote:
> FYI,
>
> I don't think this was sent to the list, forgive me if i
FYI,
I don't think this was sent to the list, forgive me if it was and I
didn't see it.
Andy
--
You probably don't have to reinstall it. If you never gave root a
password, just login as Andy says below and, when prompted for the
password, just press the ENTER key. Unless you gave root a
Alternatively you can try this if the box is unix/linux :
sudo mysqld_safe --skip-grant-tables --user=root &
mysql -u root
Change your root password
Restart mysql after this.
Cheers
Sharad
Andy Shellam wrote:
> Hi Andrew,
>
> I think he means re-install MySQL and provide a root password
Dear All,
I am interested in performing a sub query that removes duplicate records from
a temporary table prior to pushing the data to the main table.
I am not sure if it is possible and thought I would ask prior to the endeavor.
I currently use php to perform this operation but is really bogs
Hi Andrew,
I think he means re-install MySQL and provide a root password (you
said when you originally installed it that you didn't give it a
password.)
After you've done this, try mysql from the command-line explicitly
telling it to use the user "root":
mysql --user=root --password
Th
11 matches
Mail list logo
