Ubuntu Servers :: Converting MSSQL To MySQL Formatted Dump Files?
Dec 11, 2010Does anyone have a simple to use bash script or some such that will convert MSSQL dump files to MySQL formatted dump files?
View 6 Replies
ADVERTISEMENT
Ubuntu Servers :: Import Mssql To Mysql?
May 14, 2010It took a while but I got my home webserver setup and running with mysql. Now I want to import a 70MB MSSQL backup file from my hosting company. I noticed phpMyAdmin can import up to 2MB. Any suggestions on how to do this for a larger file. I do have access to the server running SSH so I'm not opposed to using the command line if I need to.
View 2 Replies View RelatedUbuntu Servers :: LAMP - Insert UK Formatted Date Into MySQL
Sep 5, 2010Trying to take a UK formatted date (30/12/2010) and insert it into Mysql (2010-12-30) is just not going to plan. I have a feeling I'm getting close, however it's just not working out.
Code:
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {
$unformatted_date = $_POST['date'];
$formatted_date = substr($unformatted_date,6,4) . "-" . substr($unformatted_date,3,2) . "-" . substr($unformatted_date,0,2);
[Code]....
Server :: Host A MSSQL DB And Use It On MySQL?
May 19, 20101. Am i able to host a MSSQL DB and use it on MySQL?
2. Where is the download link for MySQL server on Linuix (CentOS) as i can't seem to find it for linuix and is it possible to have a gui for MySQL on it if so which program would you recommend?
General :: Import Data From MySQL To MSSQL
May 6, 2010I want to import data from MySQL to MSSQL. I've been searching in the web, and I can't find a good and straight answer. How can I do it?
View 2 Replies View RelatedSoftware :: Import The Data From MSSQL Of Windows To MYSQL?
Oct 10, 2010I am migrating SugarCRM from windows server to a linux server. But the main problem is the database. How will I import the data from MSSQL of windows to MYSQL of Linux ?
View 5 Replies View RelatedUbuntu :: Add Date Suffix To File Name During MySQL Dump?
Mar 17, 2010I have a script (below) which works ok, but I have tried to modify it as I want to keep the older files for a restore if needed. I have tried adding a date suffix to the newly created files (second lump of code), but it doesn't seem to work.I get the error:
$SOURCEDIR/p1db_$DATEVAR.sql: ambiguous redirect
The working original script:
Code:
#!/bin/bash[code].....
Red Hat / Fedora :: Pipe MySQL Dump To FTP Without Writing To Disk
Aug 8, 2010I've got a Centos 5 machine running with a raid 1 SSD hard drive combo, as I don't know how or even if it's possible yet to wipe the free disk space clean I need to be careful to not fill all the free disk space. As I don't want to fill the free disk space too quickly and was wandering if it is possible to pipe the result of a mysqldump to a FTP client only writing it to the ram and not writing it to this disk.
I've done a bit of research on the subject and have found the two following commands:
Code: mysqldump < mysqldump options> | gzip > outputfile.sql.gz
Code: tar cf - / | ncftpput -c sonic.sega.co.jp /usr/local/backup.tar
I would like to combine the two to make something like this:
Code: mysqldump mysqldump_options > | ncftpput ncftpput_options -c SERVER_IP backup.sql
I haven't actually tried my code as it seems too easy and I'm sure I've got something wrong! If this command is even correct will it prevent the sql file from being written to the hard drive to my local machine?
Software :: Mysql Full Backup Script Not Archiving The Dump File?
Mar 20, 2011I have a problem with a script i wrote, the script runs fine if manually executed however it doesn't run *fully* when executed via cron
here's the script :
Code:
#!/bin/bash
FILENAME=mysql_full_dump_`date '+%m.%d.%y'`.sql
`which mysqldump` --all-databases -uroot -p************ -h127.0.0.1 > /root/$FILENAME
RETVAL=$?
[code]....
the script resides in /root/bin and the cron entry is as follows:
Code:
0 0 * * * root "/root/bin/mysql_daily.sh"
the result is the .sql file, but it doesn't archive it.
Ubuntu Servers :: Restore MySQL Databases From Files?
Jun 8, 2010How do I restore MySQL Databases from an old hdd with Ubuntu on it which won't boot? Information below is not necessary just explaining how I ended up in this situation. Today the harddrive crashed on one of my development servers and I have no recent backup of the MySQL databases on the server.
The stuff on the server weren't horrible important but it would still be nice if I were able to recover some of the files. This is the thing, I don't think the harddrive is entirely dead because it comes to a screen saying harddrive error something enter to continue then it says GRUB in the upper left corner before the computer crashes/reboots.
So I installed Ubuntu server on a new HDD and now I want to attempt to recover the databases from the old HDD by mounting it in Ubuntu but before trying I would like to know who one does that. As I've understood it's a bit more complicated then one might thing because MySQL uses binaries and not plain-files.
Ubuntu Servers :: 10.04 LTS - Mysql Fills Up / With Invisible Files?
Jul 23, 2010I'm having the oddest problem. I use Ubuntu 10 LTS on 3 Amazon EC2 "large" instances, for Drupal hosting. All three servers are seeing the same issue, where root gradually fills up with files that I cannot see by any means. ls -a , du , nothing seems to see these files except for df. And when the drive gets full (after about a week), the server behaves as if the disk is full... so I believe that df is correct here. The moment I restart mysql, all that invisible data disappears, and everything is fine again.
The MySQL datadir is on a separate device (600GB EBS mounted at /ebs ), so it's definitely not MySQL data. And /tmp doesn't have anything visible going on; certainly not something that would take up 9gb.
I suspect that something is causing the kernel to not release file handlers correctly. For all I know this could be happening with all programs, but MySQL is the only thing running that would use enough temp space to be noticed. Each server has some applications that happen on it uniquely, but since it's happening on all of them I figure it's the common elements that count. The servers are a clean install, running Apache2 (PHP 5.3), MySQL, and SSHD. All three servers were installed from the official AMI.
Ubuntu :: Dump Serial Ports To Text Files With Timestamp?
Jun 1, 2010I have a computer with 4 RS232 com-ports (MSI MS-9A19).
To each com-port, I have instruments attached that transmit data like this:
982000001088420<CR><LF>
982000001088421<CR><LF>
[code]....
CentOS 5 :: Can't Get Kdump To Generate Dump Files?
Dec 7, 2010I'm posting because I've read everything I can find on google and in the forum and the man page and still can't get it to work. I did read the FAQ, I hope I have adhered to it.I've tried several things and I don't remember exactly everything I tried and in what order.I've got several (12) HP ProLiant DL140 G3 servers running CentOS 5 that lockup about once a week. These are in a remote colo cage so I all i have access to is the built-in HP lights-out management interface, which includes a console, and ssh. I've been trying to get kdump setup to try to figure out what's going on. As an aside, if I run top on the console (via the management interface) the servers stay up for about a week, if I don't run top they crash within about 48 hours.I've used yum update to update to the latest available kernel (2.6.18-194.26.1.el5.x86_64) and installed the debuginfo and debuginfo-common RPMs from http://debuginfo.centos.org/5/x86_64/I have a single command in the /etc/kdump.conf file:ext3 /dev/sda5
View 4 Replies View RelatedUbuntu Servers :: LVM Storage - Partitions Will Be Formatted
Mar 22, 2010I wanna try to install ubuntu server on my poweredge 1955 with emc storage, but on the partitioning step it says:
"the following partitions will be formatted:
...<here goes all the lvms in the storage>..."
I already tried all the options in the partitioning step without success
Ubuntu :: Recovering Files From Formatted HDD
Jan 24, 2010While trying to create a bootable SD to install Ubuntu on a netbook, I accidentally formatted a part of a removable HDD that was connected to my computer. If I remember correctly, the partition I formatted wasn't the main partition of the HDD. In that case, does it make sense that the whole disk was wiped out? On that HDD there's a year worth of work, I really need that back.
I was using PhotoRec with some luck: it started to recover files, but with no names, which is almost useless, considering a lot of it are recordings - useless without their names. Is there any good recovery program that will recover all my files incl. names? Is there a easier oprtion, considering that I think I didn't really format the big partition of the HDD? What may it have been, the small partition?
CentOS 5 :: Reading Server Crash Dump Files
Oct 18, 2010Is there any command available inorder to read the server crash dump files?
View 4 Replies View RelatedUbuntu Servers :: Mysql Error Stopping MySQL Database Server Mysqld?
Jun 17, 2010I 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.
Ubuntu Servers :: Mysql ERROR 1045 \ Trying To Allow Remote Access To Mysql?
Jan 14, 2011i was trying to allow remote access to mysql by following mysql was running perfectly until i got here :
Code:
/sbin/iptables -A INPUT -i eth0 -s 192.168.1.0/24 -p tcp --destination-port 3306 -j ACCEPT
i changed my.cnf bind-address line to : "bind-address = 127.0.0.1" and nothing
[code]....
Programming :: Incremental Backup Using DUMP Command - Error "DUMP: Only Level 0 Dumps Are Allowed On A Subdirectory"
Sep 6, 2010I have used Dump Command to dump the application files. For Full backup the level 0 is working fine. For incremental backup I used the level 1 or 2 it is getting the error as
DUMP: Only level 0 dumps are allowed on a subdirectory
DUMP: The ENTIRE dump is aborted.
The code I used
===============================
#!/bin/bash
#Full Day Backup Script
#application folders backup
#test is the username
now=$(date +"%d-%m-%Y")
[Code]...
Programming :: Core Dump Issues. Program Crashes But Does Not Generate Core Dump File?
Oct 7, 2009I want to generate core dump files from my program when it crashes. Its a pretty big process and has about 10-11 threads in it.I have followed the documentation to enable core dump by setting ulimit to unlimited etc. I quickly tried "A demo program creating a core dump" from the following webpage, which succeeds in Segfault and dumping a core file in the directory that I configured.However, I tried running my original program and caused it to crash. I did this by making calls to kill(), raise() or the same null pointer access as shown in the webpage above. In each case, my program crashed but did not generate a core dump file. Am I missing something?My program is in C++ and my environment is Redhat 9.0 (kernel 2.4.20)
Going through the "Why do I NOT get a core dump?" section on the same webpage as above, I can see two potential problems. One - there are issues with the suid/sgid (bullet # 6). I am not able to change any settings with suid because my system does not contain either /proc/sys/fs/suid_dumpable or /proc/sys/kernel/suid_dumpableTwo, my program has threads in it and the bullet # 8 is the problem.
Ubuntu :: Files Recovery From Recently Formatted Ext4?
Mar 7, 2011Is there anyway I can recover my files that used to be on a FAT partition which I recently formatted to ext4?
View 2 Replies View RelatedUbuntu :: Recover Files From Formatted Thumb Drive
Apr 17, 2011I formatted a thumb drive on Windows (not quick format) that contains files I need (video files). Unfortunately, my attempt to recover them with both PhotoRec and TestDisk failed: neither of them found the files. I know they are still there because I scanned it with some Windows software (File Scavenger) and it detected them. I'd like to try to do this with Linux, to figure out how to do it, and save money at the same time.
View 4 Replies View RelatedUbuntu :: Recover Files After Formatted Drive To NTFS With Windows
Apr 3, 2011I accidentally formatted a drive that was ext4 to NTFS in Windows (using quick format only). I tried TestDisk, it does find a deleted partition but doesn't seem to find any files or be able to recover anything. Is there any way I can recover the files?
View 1 Replies View RelatedUbuntu :: Converting .ogg Files To .mp3?
Apr 14, 2010What are the proper ffmpeg instructions for converting .ogg files to .mp3?
I have followed several formulas, but each time I get an error message.
Ubuntu :: Converting Multiple Files (TIF To EPS) At Once
Mar 4, 2010I am converting .tif images to .eps and am trying to do a bunch of them at once. I have tried
Code:
convert *.tif *.eps
but this doesn't do it.
Ubuntu :: Converting .rpm Files To Deb For Install?
Jun 10, 2010I have heard that tclient v2 is much better than the one that comes with ubuntu or even remmina and have found a rpm package for it.
I search and found I should use alien to convert to a deb so I can install; I am getting the following error :-
sudo alien -k tsclient-2.0.2-1.fc11.src.rpm
error: incorrect format: unknown tag
mkdir: cannot create directory `tsclient-2.0.2': File exists
nable to mkdir tsclient-2.0.2: at /usr/share/perl5/Alien/Package.pm line 257.
I am running alien from the directory where the .rpm file is and while the extraction is done the creation of a deb file is not.
Ubuntu Multimedia :: Converting .wav Files To Mp3?
Nov 16, 2010I copied some songs off a CD and wanted to convert them to mp3. Is there a program that I should have used to rip them that would have done that or is there a program that will convert them for me?
View 9 Replies View RelatedUbuntu Multimedia :: Converting .nwc Files To .ly?
Jan 22, 2011Is there a way (strictly in Ubuntu -- well I am viewing the noteworthy files under wine) to convert these files to lilypond format? I have tried the nwc2ly converter, but so far without any success. Any thoughts, or suggestions? You see I have a friend that has done a lot of Orthodox Music in NWC, but I want to get it into Lilypond as it will look better, and then I can easily convert to pdf, and easily change things if needed, etc. But I would rather not have to print and retype it all.
View 1 Replies View RelatedUbuntu Servers :: Mounting Large (12TB) SCSI Attached RAID Array (formatted With Ntfs) ?
Feb 16, 2010I have a large RAID array of 12 TB attached to one of my Ubuntu server machines. The RAID volume is formatted with NTFS. The problem is that I can not mount this volume in Ubuntu. I can read it normally if I attach it to windows machine.This is the output from "sudo fdisk -l":
sudo fdisk -l
Disk /dev/sda: 164.7 GB, 164696555520 bytes
255 heads, 63 sectors/track, 20023 cylinders[code]........
General :: Recover Deleted Files From [formatted] FAT32/NTFS Drive?
Aug 22, 2011Is there like EasyRecovery for Linux? Free open source command-line based software strongly preferred.Expecting something like:
$ fat32_recovery --some-arcane-options dump.img dir/
Recovery in progress...
~ILE1.TXT -> dir/XILE1.TXT
[code]....
