Tag Info

Hot answers tagged

13

Yeah, this was a nuisance I had to deal with a while ago. Here's a snippet from a script that dealt with converting a bunch of CSV files into mysql tables: COLLIST=`head -1 $table.csv` mysql --execute="LOAD DATA INFILE '$WORKDIR/$table.csv' INTO TABLE $table FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' IGNORE 1 LINES ($COLLIST); SHOW WARNINGS" > ...


8

You want to run the dump through the mysql client. Example: mysql -uroot -p testimport < database.dump


7

It seems to me that your .sql file actually contains the text <br /> <b>Fatal error</b>: Maximum execution time of 300 seconds exceeded in <b, which is obviously not valid sql. You have possibly exported your database with some tool like phpMyAdmin, which took longer than 300s to create the export which was cut short at that point in ...


6

Try reversing the redirection: mysql -u root -p databasename < D:/database.sql '>' means to redirect the stdout; '<' redirects stdin If you are indeed using phpMyAdmin, as you say you are, you can log in to it with your same credentials and go to the "Import" tab (one before the last one) and upload the file.


6

Alternatively there's this: http://www.ioncannon.net/system-administration/1246/converting-from-virtualbox-or-vmware-to-ec2-now-easier-than-ever/ which sounds like if you just have an EC2 compatible kernel...


4

For this reason I always use mysqldump --hex-blob. Re-dump the database encoding the blobs using this switch and it will work. You can try to import it using a windows mysql client IDE like sqlyog or mysql administrator. It worked for me once.


4

If the records are already in a file, your best bet may be to edit the existing zone file directly (usually in the %SystemDir%\System32\dns folder). Open the file for the zone in question and paste the records in at the bottom of the file. Ensure the record format is the same as existing records (for example, it's simply CNAME rather than Alias(CNAME) and ...


4

If it's not all one table you might want to split into multiple files and load each one in a seperate client (it'll go faster as well as make isolating the error easier).


3

If this is not a version mismatch, then the backup file could be actually corrupted. If this is the case, you're not going to be able to (at least easily) recover anything from it.


3

log in to another mysql window and type, you'll see where it "stuck"... SHOW PROCESSLIST; using that information you'll be able to adjust your my.cnf and make that import go a lot quicker. also take a look at your mysqld.log make sure everything is clean there whenever you start mysqld, this will also gives you an indication if something is wrong ...


3

You didn't say what version. Since we're talking SQL Server, there are several ways to approach this. If you're on SQL Server 2005/2008, the easiest way is to probably use the Import Data function within SQL Server Management Studio. Actually, what this does is creates an SSIS package that allows you to bring data in to the combined database. This is a ...


3

What you want to do should work using the vboxmanage import command. Use vboxmanage --dry-run to get a list of the parameters that will be used to import the appliance, these can be over ridden by following the instructions in the output of the dry run. Import copies the appliance files to the default hard disk storage location. You may want to change ...


3

I can't answer your question directly, but perhaps help a bit anyways. First of all, I was going to do some exporting and importing when rebuilding out two Hyper-V servers as a cluster when R2 came around with Live Migration support. I tried exporting and importing, but could not get it right. I found no simple answers to why either, so I simply ended up ...


3

You may want to look at FmPro Migrator. It will convert FileMaker Pro (2,3,4,5,6,7,8,9,10) to a SQL Database (MySQL, Oracle, Access, Microsoft SQL Server, Sybase, DB2, OpenBase, PostgreSQL, FrontBase, SQLite and Valentina). You could also FileMaker Instant Web Publishing. It's part of FileMaker Server Advanced and is also part of the client FileMaker. It's ...


3

Like the others said the real problem is that for SHOW WARNINGS to work you have to be in the same connected session. mysqlimport disconnects from the session as soon as it's finished importing, making the capture of it's warnings impossible in it's current version. Sounds like an opportunity to donate a patch. :)


2

You already have a job in the target database that is numbered 99. You'll need to drop that job. Edit: The ISUBMIT procedure of dbms_job is a bit hard to find docs on. Here is where I found some. That procedure submits a job with a specified job number, whereas the SUBMIT procedure assigns a job number for you, avoiding this very problem. To remove the ...


2

It turns out I needed to have both Outlook 64bit, 32bit will not work. I also needed to assign a role to my user: New-ManagementRoleAssignment –Role “Mailbox Import Export” –User “USER” I found the solution here.


2

Try the full path to the file: mysqlimport -u wendel2go -p --fields-terminated-by='\t' b2g /home/username/Desktop/gene2accession Replace "username" with your user name.


2

There is the standalone vmware converter that will convert between different virtual machine formats. You may also want to read this which gives information on how to convert from vmware images to ec2 AMIs Or do it directly with this


2

Copy /var/spool/mqueue directory: old# tar -zpcvf mqueue.tar.gz /var/spool/mqueue old# scp mqueue.tar.gz newserver: new# tar -zpxvf mqueue.tar.gz -C /


2

In my company access to Archived PST files via OWA is unavailable so I'd always assumed that it was generally impossible under the available Exchange environments. However, I found this Technet Article that states that as long as you're using at least exchange 2010 or an updated version of 2007 you should be able to see them. Apparently they're called ...


2

This is a syntax error in the .sql file. There should be a line there with "<b>Fatal error: Maximum execution time of 300 seconds exceeded in This error looks alot like a PHP error to me. During database export/dump, php stopped after 300 seconds, and wrote out the error to its output -> your file. You should fix php.ini, to allow longer execution ...


2

This really isn't the right way to do this. What you want is to get your contacts from an LDAP server -- either Exchange or another one you set up. (the linked article is for Outlook 2007, but similar info is available for 2010). This ensures everyone has up-to-date contacts all the time (as long as they can talk to the LDAP server) and that changes get ...


2

Alright, first of all, let me say that it's pretty unclear what you're trying to do here, but painfully clear that you're doing it "wrong." First of all, as it sounds like you don't have an Exchange server, I might suggest getting one. Probably not one you manage yourself, but you can get a hosted Exchange solution dirt cheap these days (a smallish client ...


2

Let's initialize some variables for ease of use: DB_PREFIX=yourprefix_ FILE_MYSQLDUMP=/path/to/mysqldump.sql Now get a list of existing databases (excluding tables that start with the prefix you don't mind overwriting and the information_schema and mysql tables which probably shouldn't be in mysqldump.sql anyway): echo "SHOW DATABASES;" \ | mysql \ | ...


2

First, can you show the output of zpool upgrade -v? Then see: Can I trust that ZFS is consistent between Linux and FreeBSD? The pool version is 28, but "Feature Flags" have been implemented to distinguish functionality between variants of ZFS on different platforms. For instance, a zpool get all vol1 on one of my ZFS on Linux systems ends with: vol1 ...


2

You are redirecting the wrong way. Your command, as written, writes stdout of the mysql process to your .sql file. Give that angle brace a 180 degree spin and give 'er another try.


2

Simply invoke screen at a shell prompt. After it's started the shell inside screen, then run the mysql import command as normal. To detach from the screen session, type Ctrl-A, D. To reattach the session, type screen -r


2

Are you sure that the backup consisted of one file? If you have the free space on the source server that the backup came from (assuming it is still operational) you could try restoring the backup to a new database to confirm that the backup is good


2

In what form would this list be supplied, and how often would you want to update it? You could set up a cron job that copies over an access-list on a daily basis, or you could set up a BGP peer with a quagga server to feed it a list of routes, but you're not likely to find a button that says 'block these IPs'.



Only top voted, non community-wiki answers of a minimum length are eligible