General :: Restore 200+ Mysql Database With Shell Script?

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


ADVERTISEMENT

General :: Create A New Mysql User And A Mysql Database At The Shell Prompt?

Aug 7, 2010

How do I create a new mysql user and a mysql database at the shell prompt?

View 1 Replies View Related

Server :: Mysql Will Not Restore Database?

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

Software :: Mysql Restore Database And Id Commands?

Jul 22, 2010

I used this command to Backup a mysql database [name is cacti]- /usr/bin/mysqldump -uroot -proot cacti > cacti-metadata-backup.sqlHow do I restore Restore this database, on a system that has a clean install of mysql on it. Also I need to restore the owner of this data [in this case cacti]How do I restore the owner and password for create a new one.

View 1 Replies View Related

Server :: Change The Owner Of The Mysql Database With Shell Commands?

Jun 19, 2010

i want to know how can i change the owner of the mysql data base with shell commands.

View 3 Replies View Related

Networking :: Database Error: Unable To Connect To Database:The MySQL Adapter "mysql" Is Not Available

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

General :: Mysql Best SQL Database Gui Tool

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

General :: MySql Database From Usb Stick

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

General :: Database Application Using MYSQL

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

General :: Commands For Mysql Database

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

General :: Copy Mysql Database

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

General :: Backup A Particular Database In MYSQL?

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

General :: Update Mysql Database From 5.0 For 5.1?

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

Ubuntu Servers :: Mysql Error Stopping MySQL Database Server Mysqld?

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

Software :: Connecting To Mysql Database - Can't Connect To Local MySQL Server Through Socket

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

Slackware :: Postfix - Cyrus SASL Authentication - Pam-mysql - Mysql Database

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

Fedora Installation :: Database Conversion From Mysql 4.1.22 To Mysql 5 For A Client?

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

General :: Inserting Mysql Database Using Shh Putty?

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

General :: Mysql Database - Did Not Ask For An Admin Password

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

General :: Monitor The Local MySQL Database?

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

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 View Related

General :: How To Change Default Database For One User In MySQL

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

General :: Recover Deleted MySQL Database Files?

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

General :: How To Connect To Mysql Database Using Php In Apache On Ubuntu?

Apr 21, 2010

how to connect to mysql database using php in Apache on Ubuntu?

View 4 Replies View Related

General :: JDBC Connectivity (From Java To MySQL Database)

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

General :: Connect My Mysql Database Server From Outside Network?

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

General :: Starting MySQL Database Server - Failed

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

Server :: Database Stopped Showing Up - Files Still There - Restore The Database From The Files?

Jul 8, 2011

I recently moved into a new place and when I hooked up my webserver, I wasn't able to bring up my page, even from localhost. With some digging, it seems that I can't access the database that housed my posts (wordpress installation). I looked for the datadir in MySQL and that directory shows the wordpress directory that should be holding the database and all the files are still there. 1) why the database no longer shows up 2) how to restore the database from the files?

View 2 Replies View Related

General :: Partition Apache And MySQL Database (IBM X3650 M3 6x300GB SAS)

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

General :: Write A Simple Program C++ To Connect To Mysql Database?

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







Copyrights 2005-15 www.BigResource.com, All rights reserved