Red Hat / Fedora :: MYSQL Database On External USB Drive - Dumped/res?
Apr 25, 2011
I have a hard drive from a server that had a severe hardware failure. I have it attached via usb to the new server. I need to dump the database from the hard drive to a .sql file and then import the dump into the new server.
/mnt/external_drive/var/lib/mysql/ mysqldump -u root -p database name > backupdatabase.sql
My problem is, I enter in the root password, and it gives me an access denied error. I know this is the root password because that is how I am logged into the server. How can I test the credentials of the database that is located on the external hard drive? And, I've used all the credentials that could open this database (database user and root user) and still no go. If I can never get the password for the database on the external hard drive, what are my options?
View 1 Replies
ADVERTISEMENT
Oct 14, 2010
in my fedora machine i gave
mysqldump <database-name> > bakup.sql
in my solaris machine i gave
mysql <newly created dbname> < bakup.sql
it shows the below error
ERROR 1064 at line 25: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1' at line 7
mysql version in my fedora machine is
mysql Ver 14.14 Distrib 5.1.47
mysql version in my solaris machine is
mysql Ver 12.22 Distrib 4.0.24
View 4 Replies
View Related
Apr 2, 2009
I have the latest LAMP running on F10 but need to do a database conversion from mysql 4.1.22 to mysql 5 for a client.
View 4 Replies
View Related
Feb 13, 2010
Iam always working from 1 machine to another even with my laptop which i dont place all my data some of which in some machine, iam always constantly saving all my files specially my MYSQL database files which have grown in size, Is there a ways I can just copy & paste my MYSQL database? like in MSACCESS.
View 4 Replies
View Related
Jun 16, 2011
I've setup a CentOS apache web server, and loaded a site onto it. The site previously was functioning under windows xp (before I "stepped in") and wamp. What I did was copy the site in /var/www, reconfigure the httpd.conf (DocumentRoot /var/www/site, etc). Although when I try to open the webpage I get this error: Database Error: Unable to connect to the database:The MySQL adapter "mysql" is not available.
[code]...
View 10 Replies
View Related
Jun 17, 2010
I have installed Mysql in Ubuntu 9, for the use of roundcube database.After installing iam getting the error like this
* Stopping MySQL database server mysqld [ OK ]
* Starting MySQL database server mysqld [ OK ]
* Checking for corrupt, not cleanly closed and upgrade needing tables.
So because of this in the roundcube configuration its giving the error message that MYSQL is not installed. So Kindly give me a idea how to solve this.
View 1 Replies
View Related
Aug 25, 2010
I'm having problems connecting to the mysql database on my system. I first noticed this when I was trying to set up the program anymeal. I subsequently tried using MySQL Administrator (mysql-admin), but had no luck. It gives my the following feedback:
Code:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Click the 'Ping' button to see if there is a networking problem. I press the ping button, and it seems to connect.
Code:
View 4 Replies
View Related
Aug 7, 2010
How do I create a new mysql user and a mysql database at the shell prompt?
View 1 Replies
View Related
May 10, 2011
Pam-mysql can not connect to the database and below are my configurations.
saslfinger -s Output:
root@mailbackup:/# saslfinger -s
saslfinger - postfix Cyrus sasl configuration Tue May 10 10:12:10 EAT 2011
version: 1.0.2
mode: server-side SMTP AUTH
-- basics --
Postfix: 2.7.2
System: Slackware 13.1.0
-- smtpd is linked to --libsasl2.so.2 => /usr/local/lib/libsasl2.so.2 (0x00007f74ebfb7000)
-- active SMTP AUTH and TLS parameters for smtpd --
-- listing of /usr/lib64/sasl2 --
-- listing of /usr/local/lib/sasl2 --
-- content of /usr/lib64/sasl2/smtpd.conf --
-- content of /usr/local/lib/sasl2/smtpd.conf --
-- active services in /etc/postfix/master.cf --
-- mechanisms on localhost --
View 3 Replies
View Related
Jul 17, 2009
i'm new to MySQL and i designed a database using MySQL and PHP recently but dont know how to port it to my host company. How do i save the database on my flash drive then transfer to my host on my website's control panel.
View 1 Replies
View Related
Dec 16, 2009
I need to work with MySQL database management Software.
But I don't know how it is install on our computer.
I heard that their is a so many step for this process .
View 2 Replies
View Related
Oct 14, 2010
i am using fedora 12i want to bakup my mysql database and extract it in my solaris 10 machine.in my fedora machine i gave
mysqldump (database-name) > bakup.sql
in my solaris machine i gave
mysql (newly created dbname) < bakup.sql
[code]....
View 4 Replies
View Related
Dec 25, 2010
What commands can be used to install software such as "phpMyAdmin" to Fedora? As I am setting up Apache in Fedora. How to install "phpMyAdmin" and setup phpMyAdmin, so that I can use internet explorer to manage the phpMyAdmin to configure the MySQL database remotely.
View 2 Replies
View Related
May 30, 2011
I have 350GB external Western Digital USB hard Drive.When I try to remove it from the system by executing Safely Remove Drive menu the fedora 15 system gets stuck.The processor starts giving a hum sound and it goes on even if it is left for half an hour in the stuck state.The Mouse is not working and everything is halted.
View 13 Replies
View Related
Mar 30, 2011
i have installed fedora 14 with so many libraries ,development tools installed on my pc but i usually have to present some projects which can run on my system .........and can't be executed or compiled due to absence of libraries and tools there so, i there some way to so that i can use this current installation on my hard drive of my pc to some external media like external hard disk and plug and use that installation anywhere on any system..
View 2 Replies
View Related
Jun 17, 2010
I would like to know if there is a way to repair a fedora 13 installation without using yum or using smart .Both applications are exiting with a "segmenttation fault".This happend after an general update and the installation of a couple of applications when the installer exited with an error message that indicated that there was not enough diskspace left.The message was wrong because there was plenty of space left and all of the applications were installed, just important programs used for changing the systems started crashing.Here is a small list of prgs that are crashing: yum , smart, system-config-firewall, system-config-printer, abrt-gui and I guess I might find easily more.Strange rpm seems to work.
View 12 Replies
View Related
Apr 9, 2011
When my c++ app crashes I would like to generate stackdump and display dumped register values. My app runs on Fedora Linux 2.6. I would like my program to be able to generate stackdump and display dumped register values when it crashes and the next time the user run's it, it will ask them if it is ok to send these to me so I can track down the problem. I can handle the stacktrace info but I don't know how to generate these two things.
View 1 Replies
View Related
Jun 20, 2011
I am using RHEL 6. When i use CAP3 software for the first time it successfully resulted. But second time when i used, it's showing "segmentation fault (core dumped)". Even after restarting and reinstalling it showing same error. When i google, i found it some memmory related problem. But no clear information.
View 3 Replies
View Related
Aug 16, 2010
My existing MySQL database is running on 11.1. I plan to do a fresh install of 11.3 in order to utilize the trimming feature for SSD drives. How should I install my MySQL database to the new version? Do I perform a backup then restore to the new install? Or can I just save the mysql db files to a cd and somehow attach it to the new install?
View 2 Replies
View Related
Mar 25, 2010
Specifically I'm looking for a native Linux program that is similar in functionality to Navicat or SQLYog. I.e. I need something good at editing data. Free would be best, but not essential.
View 9 Replies
View Related
Jul 30, 2011
I recently installed a portable WAMP server on my usb stick. Really nice, I can do some php programming on my girlfriend's windows7 laptop without installing anything on it.I also have a LAMP environnement on my linux computer.When I plug my usb stick on my linux box, I can easily mount -o bind /usbstick/wwwfolder ~/public_html and work on my php script from there.
But my question is, is there a way I could get the database from my usb stick's MySql server, to run on my linux MySql server? So I can modify data base schema from my Linux workstation, doing some INSERTS in some tables, and then plub my usb stick on the laptop and get my up-to-date database running from the portable environnement?I don't know where / how MySql stores its databases. Basically, I want to "mount" the database from the usb stick in my Linux' installed MySql server, without extracting and importing the data, so there is just ONE database used for BOTH environnement.
View 3 Replies
View Related
Mar 24, 2010
I posted a thread regarding a CD Base Application. I can run the program, but for some reason It does not seem to work properly.
For some reason in exits the program back to the command prompt. I am using the code from Linux programming 4th edition which you can get it from here...and in the folder ch08/app you will find all you need to create the CD database application.
View 1 Replies
View Related
Nov 26, 2010
I am not having any knowledge of mysql database & in my present jobs i have to solve problem on mysql database. need some commands which are used regularily in database.
View 1 Replies
View Related
Mar 8, 2010
I want to migrate a mysql databases from a old server to a new server ( Redhat ) , can advise what I need to do ,is it just copy all .frm , .MYI & .MYD files to new server will do ? or I need to do export and inport data ?
View 12 Replies
View Related
Jun 27, 2011
How to backup a particular Databases..through Bash script! For example i have 6 databases;
Anish
linux
Software
Questions
Rhce
Google
these are the databases i have from that i want to take "Anish" and "questions" database backup regularly.
View 8 Replies
View Related
Sep 5, 2010
i need to update my mysql database from 5.0 for 5.1, i have several java application and php application running on that server, without disturbing the setup i need to upgrade the server can someone suggest a method of doing this
View 2 Replies
View Related
Jul 28, 2009
I tried creating a database in mysql but couldn't do so...here is the message i got from the shell:
Code:
View 4 Replies
View Related
Feb 21, 2011
I am having a problem restoring a database. Server is Ubuntu 8.04.4 LTS. It appears to wig out at a certain point, when this happens the output on the screen shows;Quote:
0,4),('2011-02-21 03:30:32','Queue Wait Outside (100)','Queue Wait Outside (100)',11,0,4),('2011-02-21 03:30:49','Queue Wait Sleep (30)','Queue Wait Sleep (30)',5,0,4),('2011-02-21 03:30:53','Queue Wait Sleep (30)','Queue Wait Sleep (30)',13,0,4)
[code]...
View 2 Replies
View Related
Feb 28, 2010
Well i have got a problem with connecting to a mysql database using php. I used this package "mysql-noinstall-5.1.44-win32.zip" and extracted it to c:mysql and added c:mysqlin to the PATH variable and used the following command in command prompt to start mysql: c:mysqlinmysqld --standalone
well mysql did start and everything went well accessing mysql in command prompt. Well under the database "mysql" in the table "user" i created a new user "php" with a password="****" and hostname = "localhost" but when i try to access this database with a following php routine:
And when i accesses it with my browser using localtost/test.php, all i get is "localhost" displayed on screen, "Connected to mysql" never gets displayed not i get any error..i am using windows 7(32-bit-ultimate)and mysql 5.1.44.
View 8 Replies
View Related
Jun 18, 2009
I am wondering whether it is problematic to let several different programs/php-scripts use the same MySQL-database concurrently, provided that they do not use the same tables?
View 5 Replies
View Related