Try this...
mysql -u root -p database_name_here < squirrelmail.sql
I'm looking at a copy of my mySQL backup files. The script creates tables
and populates them with data. Create a database and run the above command.
Should work.
This will copy your database into an sql scrip
> This will copy your database into an sql script. Take that script and
> run
> "mysql -u root -p < squirrelmail.sql"
I did what you said, but got this error:
ERROR 1046 at line 16: No Database Selected
Any ideas?
Jody
--
redhat-list mailing list
unsubscribe mailto:[EMAIL PROTECTED]?subject
> How about using mysqldump?
> Just can't seem to figure it out...
>> Should work for moving a database to another server. Give it a try :D
Sounds like you are missing a step. Here is what I did.
/PATH_TO_MYSQL/bin/mysqldump -u root --password=ROOT_PASSWORD DATABASE_NAME
> /backup/hotbacku
mysqladmin -u root password YOUR_PASSWORD
-Original Message-
From: Jody Cleveland [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 06, 2003 2:30 PM
To: '[EMAIL PROTECTED]'
Subject: RE: moving mysql database from one server to another
> Do a
>
> rpm -q p
It's not an error, it's just a warning that you're running MySQL without
a root password...not a good thing. In phpMyAdmin, click on the
dropdown menu in the left frame, and select "mysql". On the links that
open up below that, click on the user link, then select the "Browse" tab
on the page
Then you need this one
http://www.redhat.com/swr/i386/php-mysql-4.2.2-8.0.5.i386.html
Jody Cleveland wrote:
Do a
rpm -q php
Got:
php-4.2.2-8.0.5
--
redhat-list mailing list
unsubscribe mailto:[EMAIL PROTECTED]?subject=unsubscribe
https://listman.redhat.com/mailman/listinfo/re
> Do a
>
> rpm -q php
Oops, my bad. I updated php, and re-ran the rpm file, and it worked great.
One question about phpmyadmin. I get this error:
Your configuration file contains settings (root with no password) that
correspond to the default MySQL privileged account. Your MySQL server is
ru
> Do a
>
> rpm -q php
Got:
php-4.2.2-8.0.5
--
redhat-list mailing list
unsubscribe mailto:[EMAIL PROTECTED]?subject=unsubscribe
https://listman.redhat.com/mailman/listinfo/redhat-list
> How about using mysqldump?
Just can't seem to figure it out...
> Should work for moving a database to another server. Give it a try :D
Here's what I ran:
mysqldump --opt squirrelmail | mysql --host=172.30.2.61 -C squirrelmail
That gave me the error:
ERROR 2013: Lost connection to MySQL serve
PHP might have been updated, but the php-mysql package isn't installed
(which you will need for php to talk to mysql)
Do a
rpm -q php
Jody Cleveland wrote:
Do a
rpm -q php-mysql
It says package not installed.
I tried downloading the rpm you recommended, and it gave me an error. I'm
On February 6, 2003 03:15 pm, Jody Cleveland wrote:
> I tried just copying them over, but that didn't seem to work.
> I tried installing this, but got this error when trying to run it:
> cannot load MySQL extension,
> please check PHP Configuration.
please don't make your life so hard. i
How about using mysqldump?
I had a problem where one of my developers munched my database. Fortunately
for me I setup a cron job keeping several days of mysql dumps handy (plus
tape backups).
Rather than fight the dba battle (which I'm still a newbie btw) I simply
dropped the tables and reimpor
> Do a
>
> rpm -q php-mysql
It says package not installed.
I tried downloading the rpm you recommended, and it gave me an error. I'm
pretty sure one of the updates once I setup the machine was for php. So, the
error said something about being the wrong version number.
Jody
--
redhat-lis
Jody Cleveland wrote:
you should do a dump from your old db, and import that into your new db.
Something like
phpMyAdmin would make this task easy if you're unfamiliar
with command line MySQL.
Search Google for "mysql dump database".
You should end up with a text file full of the necessary SQ
Do a
rpm -q php-mysql
Jody Cleveland wrote:
If you installed Apache and PHP via RPM, you can install the
php-mysql
rpm, which you can get here
I installed it as part of the initial setup of the pc. Same thing?
--
redhat-list mailing list
unsubscribe mailto:[EMAIL PROTECTED]?s
> If you installed Apache and PHP via RPM, you can install the
> php-mysql
> rpm, which you can get here
I installed it as part of the initial setup of the pc. Same thing?
--
redhat-list mailing list
unsubscribe mailto:[EMAIL PROTECTED]?subject=unsubscribe
https://listman.redhat.com/mail
If you installed Apache and PHP via RPM, you can install the php-mysql
rpm, which you can get here
http://www.redhat.com/swr/i386/php-mysql-4.2.2-8.0.7.i386_dl.html
to install it, just use the rpm command
rpm -ivh php-mysql-xxx.rpm
If you installed from source, you're going to have to
> You could just copy over the directories (databases), and that should
> work. However, to avoid possible conflicts between your old
> MySQL and you new MySQL (there shouldn't be any, but)
I tried just copying them over, but that didn't seem to work.
> you should do a dump from your old d
You could just copy over the directories (databases), and that should
work. However, to avoid possible conflicts between your old MySQL and
you new MySQL (there shouldn't be any, but) you should do a dump
from your old db, and import that into your new db. Something like
phpMyAdmin would
Jody Cleveland wrote:
-
Well, I've got my redhat 8 production server almost done. My question is,
how do I move the mysql databases from the test server to that one? Can I
just copy the folder across, or is there something else I have to do?
-
from another em
I have had very good luck just copying the folder across from one server
to another. In fact, it even works when copying mysql databases from
windows to linux. I had Apache/mySQL running on a Windows 2000 box for a
while, and when I wanted to move the databases to my Redhat box, I was
able to jus
21 matches
Mail list logo
