Tag Info

Hot answers tagged

11

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" > ...


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

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...


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.


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 ...


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

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. :)


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

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 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 ...


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

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

You can set the environment variable NLS_LANG before executing imp or sqlplus. On windows system, if this environment variable is not set, Oracle will look into the windows registry. C:\>set NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P15 C:\>sqlplus vnz/[...] [...] SQL> select to_char(sysdate, 'month') from dual; TO_CHAR(S --------- october SQL> ...


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'.


2

You need to locate the various database files on your old hard disc. There will be a minimum of one data file (*.mdf) and one log file (*.ldf). Then copy them over and attach them using SSMS (Right click the "Databases" node in object explorer and choose the "Attach" option in the context menu).


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 ...


1

It doesn't just copy the data - the DBMS has to write the data into a table and maintain indexes. To avoid fragmenting the indexes and to increase overall throughput, it will add a whole load of records at a time and amend the indexes in chunks too - meaning that there will be periods when it's doing high volumes of writes the database file(s) and low ...


1

I'll start by admitting I've never even heard of Kloxo, but my general solution to "how do I bulk-migrate mail from server A to server B" is to find out if both source and destination servers support IMAP, then use an IMAP client that deals well with bulk operations - personally, I prefer alpine - and bulk-copy the contents, one folder at a time, from source ...


1

I finally solved the issue in what seems like a ridiculously simple way. I've seen so many posts regarding this problem but the only solution I found that worked was one that was somewhat hidden in a stackoverflow post. It turns out the issue can be solved at connect time (which makes sense): mysql_connect(HOST,USER,PASS,false,128); The answer is right ...


1

You are importing data into a database using the AL32UTF8 characterset (this is the default). The importer must therefore convert the characters to fit that and some will become multi-byte characters as you have found. There are two ways to deal with this: 1) If you don't need Unicode in the new database recreate it in the same characterset as the old ...


1

Have a look at the bcp utility (bulk copy). It only does a table at a time, but here is a script that will do the entire thing. As for a single command to export an entire database, it appears from this StackOverflow question that it is not possible.


1

If you're running MS SQL Server 2005 I think what you are looking for is Integration Services. This is a product which does many things including import and export. This replaces Data Transformation Services which is your main option on earlier versions. The easiest way of managing this is to use the Import and Export Wizard in SQL Server Management ...


1

I figured out the answer. In exchange powershell ... > $mbx = Get-Mailbox someUserName > $mbx.EmailAddresses | where { $_.IsPrimaryAddress -eq "False" } | Export-CSV "C:\SomePath\wherever.csv" > $mbx.EmailAddresses | where { $_.IsPrimaryAddress -eq "False" } | foreach { $mbx.EmailAddress -= $_.SmtpAddress } > Set-Mailbox someUserName ...


1

Batch http://stackoverflow.com/questions/2763875/dos-batch-file-include-external-file-for-variables Bash http://stackoverflow.com/questions/192292/bash-how-best-to-include-other-scripts


1

LDAP users will not be present in /etc/passwd. In a Unix system, /etc/passwd is only one of a number of places it can look for directory information, including users and groups. Where it looks is controlled by /etc/nsswitch.conf. To see if you actually have successfully imported your users in a way Ubuntu understands, use the getent command to retrieve ...


1

This kind of problem simply screams out "scripting". In essence: Create a master copy of the file to distribute Create a list of the places a file needs to go Have the script read the list of destinations and copy the master file to each If you change the master file or the list of destinations simply rerun the script. Extremely simple and extremely ...



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