How To Merge A Database Into A New Empty Database

Apr 13, 2007

How to merge a database into a new empty database?

I used this method and its not working
mysqldump --opt -uusername -p databasename > databasename.sql

mysqldump --opt -uusername -p databasename < databasename.sql
but get this error

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

View 6 Replies


ADVERTISEMENT

How Set Up Cron Job Auto Empty A Tables Of A Database

Dec 20, 2008

How to set up cron job auto empty a table of an database at specify time.

OS: Centos 5 64 bit , Cpanel: cPanel 11.24.4-R32486 - WHM 11.24.2 - X 3.9

View 11 Replies View Related

Plesk 12.x / Linux :: Unknown Database Atmail When Selecting Database

Nov 20, 2014

When I update servers via CLI autoinstaller, I always (afair) get this mysqldump error message:

Code:

Stopping psa... * Stopping Plesk engine pool manager sw-engine-fpm
...done.
done
-- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.

mysqldump: Got error: 1049: Unknown database 'atmail' when selecting the database

===> Cumulative APS controller database (apsc) upgrade has been started.
===> Cumulative upgrade of APS controller database has been completed.
===> Cumulative Plesk database upgrade (revertable stage) has been started.
===> Preparing Plesk database upgrade (revertable stage).
===> Cumulative upgrade of Plesk database (revertable stage) has been completed.
Reading package lists...

There is no database "atmail" on any of our Plesk servers. Simple solution should be to first check if the DB exists before performing actions on it.As a bonus, perhaps it would be possible to suppress the warning about mysql.event.

View 5 Replies View Related

Apache :: Database Error On All Non-database Webpages

Mar 15, 2013

I've just built a new LAMP server and I'm having a little issue where Apache doesn't serve a simple non-database webpage, instead, I get an error on all my virtual-host in the browser: Database Error: Unable to connect to the Database: Could not connect to MySQL.

I've googled the problem but since the error mentions MySql, everything I find is related to connecting to MySql, which I'm not trying to connect... and I've contacted my Linux mentor about this issue... This is something I've never seen before... don't know why Apache thinks I'm trying connect to MySQL on every browser call to the server...

However, MySQL is accessible via telnet, and all my permissions are correct...

View 1 Replies View Related







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