3
votes
3answers
78 views

How to concate strings in a bash script to use in SQL-Statement? [closed]

I would like to do the following in a bash script: read some filenames out of an file with filenames set a variable input path concat 1. and 2. use 3. in sql-statement Here my code: ...
1
vote
1answer
259 views

mysql statement in bash shell script does not work / syntax error

hope someone can help me! I do not know what's wrong with this script (Bash / Ubuntu 12.04 / Mysql / XAMPP 1.8.3). Try to read an input file with a list of csv-filenames (449-R11, 449-R12 ..) in order ...
0
votes
2answers
510 views

accessing MySQL using terminal in Ubuntu 13.04

accessing phpmyadmin db from terminal now in ubuntu 13.04 i firstly installed mysql server with sudo apt-get install mysql-server mysql server version 5.5 now in terminal i can check if it is working ...
0
votes
1answer
53 views

Terminal command repeated twice to work

I am very new with linux and ubuntu. Installed it in VMWare Player yesterday and I've been watching some good command tutorials. I've installed mysql and php and some stuff. I've created a database ...
1
vote
3answers
9k views

How to run mysql command from terminal?

I have the following sql command which I usually run in phpmyadmin by selecting the database, then running it in the command window. DELETE FROM `wp_posts` WHERE `post_type` = "attachment" However ...
0
votes
1answer
72 views

Strange message now appears when I open up my terminal

I was recently installing MySQL and everything seemed to go just fine, however, when I opened up my terminal to test a few things out, I got a strange message: No command '“alias' found, did you ...
0
votes
1answer
169 views

How do I setup php and mysql cronjobs on ubuntu 12.04 server?

just made a lamp install adn got sftp working. My question now is how do I setup cronjobs in ubuntu server? I need to make some cronjobs for my php/mysql application. Look for un-activated users in ...
2
votes
4answers
996 views

Why I can't open mysql 5.6.10 from terminal on Ubuntu 12.10?

I've always used Ubuntu to host my servers and I wanted to try the new MySQL version. So I downloaded MySQL 5.6.10 (.deb) from their official site and installed it like this: Tutorial for MySQL ...
3
votes
1answer
565 views

Run mysql queries in ubuntu 10.04 shell (cmd) stored in a files (desc order by filename)

I have a folder with about 40 SQL scripts with varying names, All using the pattern number description.sql. The file number consist of 2 digits and goes from 01 to 40, not all numbers in this range ...
2
votes
1answer
2k views

Take text from a file and insert to a mysql table using a script

I would like to take data (some text) from a file and insert it into a mysql field, using a script. I have tried: mysql -u root -p password dbname << INSERT INTO tblename (fieldname) VALUES ...
0
votes
4answers
10k views

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

I've been struggling with this issue for a really long time. Can someone please advise me on how to get mysql working? root@me:~# start mysql start: Job is already running: mysql root@me:~# mysql ...
3
votes
3answers
6k views

Is an easy way to import .dbf file contents into MySQL in terminal

I've got this files: /referencias$ ls | grep .dbf avenidas.dbf barrios.dbf borde.dbf construcciones.dbf espejo_de_agua.dbf manchas_urbanas.dbf manzanas.dbf plazas.dbf I want to do but in the ...
0
votes
2answers
759 views

Terminal says 'Broken package' when using apt-get to install phpMyAdmin

I have tried to install phpMyAdmin using the sudo apt-get install phpmyadmin command> The terminal says that there are "uninstallable" dependencies, therefore the package is broken.Perhaps the ...
6
votes
1answer
5k views

How can I export MySQL database manually - without phpmyadmin [closed]

My phpmyadmin doesn't work, i see only white blank page when i open it(it's has some issue), However, I'd like to export my project databased manually to another computer. i saw all my databases ...