0
votes
1answer
22 views

How do i export a database in ubuntu to specified location using terminal

I get a blank screen since i have installed the ATI graphic drivers. I tried a lot of things restore my laptop but all in vain. Only formatting seems to be the other option. So i want to export my ...
0
votes
0answers
18 views

Virtualmin/Webmin on Ubuntu MYSQL server root user doesn't work anymore

I was trying to make some configuration from Webmin on my server and suddenly I don't know what I've done but I receive the following error: The full MySQL error message was : DBI connect failed : ...
1
vote
2answers
40 views

MySQL takes ages to load (only when using WP)

I'm not sure what's happening but it's since a while that I'm experiencing using my dev site (running on a VM) on the local Ubuntu machine. The site runs on a Wordpress instance using MySQL setup to ...
0
votes
3answers
64 views

mysql questions for beginners

ok, I have a few questions regarding mysql. I am currently running ubuntu 12.04.4 LTS command line version. I am looking for a database that I can use. I am confused at this point because I am ...
0
votes
0answers
16 views

Test dev website

The task is to drop a few MySQL tables from a dev site and test if that generated any errors on the site, before doing it on the live site. Since the site is also a live site, I included the dev site ...
1
vote
1answer
33 views

mysql won't be installed on ubuntu

i tried to install apache on ubuntu, and worked, i tried to install php5 on ubuntu, and thats worked too. but if im installed mysql, it wont be installed, i didnt know whats going on, i'm new to ...
0
votes
0answers
23 views

“Error:Unknown option -D” while Simple Query Interception

I am working on MySQL proxy using lua.So i am trying for simple query interception.Using this link,i have done the following. I created a file example.lua,with the following code function ...
0
votes
0answers
25 views

How do I connect a mysql client? [duplicate]

I'm trying to run mysql in Ubuntu by running mysql -u root -p in the terminal and getting this error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
0
votes
1answer
30 views

Quick way to dump a Wordpress database without digging through configuration files?

I've got a load of Wordpress sites to move around and modify this afternoon. Yay. Like any good developer, I want to back up things before I Hulk-out and break everything. The site's files are mostly ...
3
votes
3answers
196 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
474 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
2k 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
55 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 ...
2
votes
3answers
16k 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
89 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
208 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
1k 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
580 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
12k 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
7k 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
797 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
7k 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 ...