General :: Restoring The Dumped Database In Mysql?
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
ADVERTISEMENT
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
View Related
Aug 17, 2010
error at restoring dumped sql
I have backuped sql by mysqldump on mysql version 5.1.41. But when I restore this sql by command "mysql -uroot --default-character-set=utf8" my-db < my-sql.sql" I've got this error message.
Quote:
#1064 - 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 'barunarum',1,1,1,1,1,1,1,1,1,1,3,3,-1,5,1,-20,0,'','script|iframe',0,0,0,0,0,0,0' at line 1
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
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
Sep 19, 2010
I currently backup my database using MySQL Administrator. I wanted to test out restoring the database, so on my test server I deleted the database and restored the .sql file to a new schema with the same name as the old. one. It appears to complete the process just fine. But I noticed that the number of rows for the restored database is slightly less than what was backed up.
Is this normal or should the numbers be exactly the same? It's only a difference of about 28 rows. I seem to be able to view the data just fine in the query tool.
View 4 Replies
View Related
Jun 9, 2010
We have a disaster recovery solution for our database where a dump file is generated daily at 1:00 AM. We have tested importing the file, along with running another sql file that generates the appropriate database user accounts, into a database on a third-party server.
One question that came up was the following: Suppose the database crashes in the middle of the day, prior to that there were transactions that were entered into the database between the time the dump file was generated, and the crash occurred. We can restore the dump file to either the main or backup server. How can the transactions that were made between the time of the dump file and the crash be restored as well?
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
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
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
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
Jul 24, 2010
I've down loaded mysql database file and now I'm looking at adding it into a new dedicated server. Should I upload that sql file to the root folder I created for the domain and insert it with shh like that? If not where should I upload this mysql file to insert it to the new database. It's rather large so I have to use SHH Fir example if this is the code,
Code:
mysql -uUSERNAME -pPASSWORD DATABASENAME < MYDATABASE.sql
where is that actual location of MYDATABASE.sql
View 8 Replies
View Related
Feb 26, 2010
I am not new to linux, but am to mysql. i run a website, on which i decided to put vpet, a virtual pet php thing. now in the instalation of this thing, it did not ask for an admin password. but it did come with a database. so i'm guessing the login is hidden in there. heres the question, i have phpmyadmin. how the heck do i read the database?
View 3 Replies
View Related
Jan 20, 2010
I have installed mysql in my local machine having centos. i also installed nagios in the same machine nagios is running fine by monitoring the local host. Now i need to monitor the local MySQL database and so i installed check_mysql_health plugin and followed the steps as given in the file.
when i try to give the command
./check_mysql_health -H mysqlhost --user nagios --password wipro --mode threads-connected
i got the error like
CRITICAL - cannot connect to information_schema. install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC contains: . /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.7/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.6/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl/5.8.7
[Code]....
I installed mysql Ver 14.12 Distrib 5.0.87 after removing the version that comes along with the centos, is this things relates to my error?
View 2 Replies
View Related
Sep 12, 2011
Though this might seem like a [URL] question at first glance I don't think it is. I have a mysql database on a server at work. Every time I log in to execute a query, I have to manually select the one database I want from the one database I have, which is a waste of time. Is there any way for me as an end user to set a default?
View 2 Replies
View Related
Sep 4, 2010
Some a$$ hack me MySQL and deleted all my databases, I have older copies on my system, but is there a way that Ubuntu server can recall or recover deleted MySQL database files ?
View 8 Replies
View Related
Apr 21, 2010
how to connect to mysql database using php in Apache on Ubuntu?
View 4 Replies
View Related
Apr 22, 2011
I have installed open suse linux 11.3. I have mysql database and jdk 1.6.20.0. How do I connect from java to mysql database?
View 2 Replies
View Related
Mar 3, 2010
How to connect my mysql database server from outside network. because its locally works and i cant able to connect from outside and different networks. when i try i am getting like this error.
ERROR 2003 (HY000): Can't connect to MySQL server on '123.136.126.179' (113)
View 2 Replies
View Related
Jul 28, 2011
Mysql can't start after I uploaded my.cnf file in /etc directory before that everything was okay but after I uploaded my.cnf and then restarted the mysql it can't boot
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
I tried to delete my.cnf and try again but the same error ...
View 5 Replies
View Related
Jul 22, 2011
I have 200+ mysql database dump in tar.gz format. Restoring all of them one by one is very time consuming. Is there any way so I can restore all these database in a single transaction.
View 1 Replies
View Related
Dec 17, 2010
how to configure a web/database server.
Given:
IBM x3650 M3 with 6 x 300GB SAS and 16GB RAM CentOS 5.5 (LAMP) Software RAID with LVM haven't tried hardware RAID.
Here's the task:
Task 1. 3x300GB SAS will goes to /boot, /root, /var* and swap (RAID1 for /boot and RAID5 for the rest with LVM). Task 2. 3x300GB SAS will goes to MySQL Database (RAID5 and LVM). * My web content will be stored here. (/var/www/html)
I know how to perform Task 1, but I'm not familiar with Task 2. So how it can be done? What specific directory should i used to store my database?
View 1 Replies
View Related
Sep 5, 2010
I'm trying to write a simple program c++ to connect to Mysql database based in my 127.0.0.1 server:
int main (void) {
cout << "33[2J" << "33[0;0f";
MYSQL mysql;
MYSQL *conn;
[code]....
View 2 Replies
View Related
