Tag Info

New answers tagged

0

In the manual of anki there's a help, the anki cards are written in XML, and te template has a similat sintaxis http://ankisrs.net/docs/manual.html#cards-and-templates Importing Anki can import text files, packaged Anki decks created by the export feature, Mnemosyne 2.0 .db files, and SuperMemo .xml files. To import a file, click the File menu and then ...


0

Instead of copying the data folder from one MySQL installation to another (which is unreliable), why not use something like mysqldump? Example of usage: mysqldump --all-databases > mydb.sql And then to import in the new database: mysql < mydb.sql


0

I wanted the prompt to be in the title of my terminals, which is essentially the same problem as wanting a colored prompt, just a different escape code. Came across this and wondered if I could do it without having to remember a special alias like the colormysql etc mentioned in the answers. I've added the following to my .bashrc which does the trick on my ...


0

Note that your PATH is build of several "paths" all separated by ":". If you want to go to your mysql/bin directory, try the following command: cd /usr/local/mysql/bin The MySQL application binary files should be located in its bin directories. When you run the command mysql in terminal, essentially you are launching the executable located in the bin ...


0

Can you copy the mariomansion directory and all its files in /home/42406/var/lib/mysql to /var/lib/mysql? That's where the database files reside on a CentOS system, but you will need root access to /var/lib/mysql to put them there. You can try: cp --recursive /home/42406/var/lib/mysql/mariomansion /var/lib/mysql/. If you have root access to the server, ...


1

Assuming two databases are db1 and db2, we can do following: 1) Take backup of db1 & db2 for rollback options: mysqldump -u<root> -p<pass> --databases db1 db2 > db1_db2.sql 2) Take backup of db1 (only data): mysqldump -u<root> -p<pass> --no-create-info db1 > db1.sql 3) Load db1's dump to db2: cat db1.sql | mysql db2 ...


0

I tried going to: C:\wamp\bin\mysql\mysql5.6.17\data and deleted the following: auto.cnf, xxxxxxxxx.err, xxxxxxxxx.pid, ib_logfile0 and ib_logfile1 But I left the ibdata1 alone as it references all local databases. I then restarted wamp and it worked like a charm.


0

I wrote mysqldumpsplitter (shell script), which splits the databases/tables as instructed in a quick and easy way. See all the possible use cases of how-to extract from mysqldump. sh mysqldumpsplitter.sh --source mysqldump-file.sql --extract DB --match_str database-name


0

There are lots of options. If you want to make standalone application, some prg. language with graphic library does the job Lang: C++, Java, Python, Ruby Lib: wxWidgets, QT, TK Or web with some framework: PHP (Nette, Symphony) Ruby (Rails) Python (Django, web.py) and so on. Now, go for google :)


0

select * from table1 where table1.worktype_unique = table2.worktype_unique AND table1.quanity<=table2.quantity_max AND table1.price <= table2.max_price; add as many and conditions as you want. This will detect non matching values only for manual fixing. select * from table1 where table1.worktype_unique <> table2.worktype_unique; Produces a set of ...


1

To find these cases, look for any characters that may be interpreted as a delimiter, or a complex or unclosed quote. Remember that if there is a newline as part of a field value earlier in the file, your line numbering may be off, so the line you are looking at may not be the one that the import is complaining about. Also try importing the CSV file into ...


2

The word update is in there twice try this UPDATE table1 SET block='1' WHERE email IN (SELECT db2.table2.email FROM db2.table2 WHERE db2.table2.status_id='10');


0

If you login via TCP/IP, you need to specify port and protocol mysql -u myNewUser -p -h 10.0.1.2 -p3306 --protocol=tcp Then, it should work. To verify, when you login, run this mysql> SELECT USER() AttemptedToLoginAs,CURRENT_USER() MySQLAllowedMeAs; If AttemptedToLoginAs and MySQLAllowedMeAs both say myNewUser@%, you did it right.


0

What you are describing sounds like this: some terminal emulators can be told to pretend that wheel-mouse events are up/down arrows rather than page-scrolling. While there may be a special control sequence or configuration setting (such as alternateScroll with xterm), generally that is activated by the switch to/from full-screen (or the alternate screen) in ...



Top 50 recent answers are included