No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
|
I am using 'MYSQL' datasource in ODBC' for my project. My deployment is failing with the error "Error 1 An attempt has been made to use a data extension 'ODBC' that is either not registered for this report server or is not supported in this edition of Reporting Services. 0 …
|
|
|
I have a .sh script which is as follows. #/bin/bash ssh uname@111.XXX.111.XXX | mysqldump -u uname -p test_db>/home/dm/Downloads/test.sql # script ended I want to extract the script from the server "111.XXX.111.XXX" and keep it in a server directory but I do not want to log in to the server. So, … |
|
|
I have a shell script like as follows #!/bin/bash # Downloading Dumps from the production server. Date=`date +'%d-%m-%y-%H-%M'` BACKDIR=/home/tmp/Backup #IP Address of the Server Host="localhost" #User Name USER="root" #Database Name DBS="test_db" echo "Backing up MySQL databases..." echo "Time: `date`" mysqldump -h $HOST -v --user=$USER --password=$PASS $DBS test_tbl1 test_tble2 ...... > … |
|
|
I am not able to restore sql file from linux command prompt. I have used the below command. Here is the message.No table is restored. I am running this in my local machine adminuser@virtualboximagescom-VirtualBox-34s7dkv4:/$ mysqldump -u root -p replication_test </home/adminuser/Downloads/rp.sql Enter password: -- MySQL dump 10.13 Distrib 5.5.28, for debian-linux-gnu …
|
|
|
I have a database on both the servers with different table values and a third server with the same named db and tables in MYSQL server1-db1-table1 table1 ID Number 1 101 2 102 3 103 server2-db1-table1 table1 ID Number 4 201 5 202 6 303 How can I merge these … 
|