MySQL is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. MySQL is officially pronounced /maɪˌɛskjuːˈɛl/ ("My S-Q-L"), but is often pronounced /maɪˈsiːkwəl/ ("My Sequel"). It is named for My, the daughter of Michael Widenius ...
0
votes
2answers
19 views
How to connect to MySQL server in LAN
Ok, Here is the technical description.
My laptop's config:
Ip Adress:192.168.2.5
Mysqlserver 5.0 on port : 3306
Operating system: Ubuntu
the database is in this machine
My friend's laptop ...
0
votes
1answer
14 views
Remote restore gz mysql database
I tried
$> ssh root@ip "gunzip < [backupfile.sql.gz] | \
mysql -u [uname] -p[pass] [dbname]"`
but get the error:
ERROR 1044 (42000) at line 42: Access denied for user '[uname]'@'%'
...
-1
votes
1answer
16 views
How to secure Magento [closed]
I'm learning magento, I basically have two questions:
How secure is the admin area login? The page doesn't appear to be encrypted so wouldn't my password be being sent in clear text to the server?
...
1
vote
2answers
109 views
How do I clear all data in a MySQL database while maintaining the table structures?
Using MySQL CLI, how can I remove all data in a given MySQL database without changing any table's structures?
-1
votes
1answer
34 views
Connecting to my new server [closed]
I have bought the hosting and now I have successfully created a database and new user and I have enter phpmyadmin from cPanel to create database.
Now everything is done. But where can I find ...
0
votes
0answers
14 views
Handling databases (without copying) when using multiple versions of XAMPP
I have just installed version 1.7.7 of Xampp in C:/Xampp1.7.7 folder. The older version exists at C:/Xampp Both these versions have different versions of PHP, MySQL, Apache...
So to test a site I ...
1
vote
1answer
22 views
MySQL - Avoid table locks during backup
I am running nightly backups on my server using mysqldump. Unfortunately that pretty much kills my site for half an hour or so every night, since the tables are getting locked during the backup.
...
0
votes
1answer
37 views
WAMPstack (BITNAMI) Mysql not working anymore
Ok, I'm in big trouble. On my computer I have bitnami WAMPstack installed. And today my MySQL stopped working. I changed nothing really. The service just stops by itself. If I restart the service ...
1
vote
0answers
11 views
Creating database from dump, InnoDB tables created, ISAM tables not [migrated]
Hey I'm getting a weird issue with mysql dumps on a Linux box
Reproducing:
Dump from mysql on box 1, the database has a mix of InnoDB and ISAM
tables
Copy the dump to box 2 Create a new database ...
0
votes
1answer
42 views
Import a local SQL File To a Remote Server Using SSH Tunnel
I have a connection between my localhost and a remote server using putty SSH tunnel.
Thats fine.
Now I need a command to get the sql file on my local machine i.e. c:\folder\test.sql and import it ...
-1
votes
0answers
16 views
Counting the number of people in a team with an SQL Stored Procedure [closed]
I am wanting to create a stored procedure that accepts the team name and year and returns the number of players in that particular team for that particular year. I am working with MYSQL and listed ...
1
vote
2answers
79 views
Can't get MAMP Pro 2.0.5 to work
I've been using MAMP for years. Rarely had any issues. I'm currently running OSX 10.7.4. I just upgraded MAMP to v2.0.5 and bought/installed MAMP PRO... but I can't get it to work. I can still you ...
0
votes
1answer
41 views
What command in MySQL is like the command “host” in oracle sqlplus
Oracle sqlplus allows you to drop down to a system command line shell which lets you run operating system command like ls, cd, cp, etc.
Here are examples SQL*Plus_FAQ, docs.oracle.com
Is there some ...
1
vote
0answers
21 views
Where from/to install my.cnf for percona db
I am new to Percona db. I just realized that by default percona does not have a my.cnf file installed. I found this from,
https://bugs.launchpad.net/percona-server/+bug/673844
In case, I need a ...
0
votes
1answer
47 views
Mysql not starting with changed datadir
I was looking for a way to store my mysql databases on a different partition than the default installation. I found this link and followed the steps.
However, after having changed the line datadir = ...
1
vote
2answers
32 views
Cant log in to Mysql
When I try to log in to mysql using mysql -u root -p it gives me this error:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
I have looked ...
0
votes
1answer
957 views
Install MySQL 5.1 on Ubuntu 12.04
Only version 5.5 is available through apt-get, but I want to install 5.1.
Is there a way to install it through apt-get? Perhaps by adding a certain repository.
How can I install it manually without ...
1
vote
2answers
31 views
Duplicate/Reroute port to another port
I'm running a Windows Server 2008 R2 machine and was curious on if there is any software out there that would allow me to open port 3307 and route any data sent to it to port 3306. For example, if I'm ...
-3
votes
0answers
10 views
XAMPP LAMPP installation error and unistalling [closed]
today i installed xampp from their website and just downloaded and extracted on my linux os (using tar xvfz) command and i started it using /lampp start.
everything started perfectly and i wanted it ...
2
votes
1answer
62 views
Grant MySQL user ability to create databases, and only allow them to access those databases
Is it possible to grant a MySQL user the privileges to CREATE new databases, such that they have full access to the databases they create (including the ability to DROP those databases). But other ...
0
votes
0answers
368 views
On Ubuntu 10.04 Server, make mysql start at boot?
I did a apt-get update & installed few updates on my server which runs 10.04LTS. But this has broken mysql. it doesn't start at boot. I tried to manually start it using the following commands:
$ ...
2
votes
2answers
30 views
How to show progress during the loading of a large sql dump?
I'm occasionally running gzcat dump.sql.gz | mysql5 -uroot -p dbname which can take hours to complete.
Is there a simple, elegant way to show some progress percentage?
0
votes
0answers
34 views
Extract the relationship between tables from an sql file
I have an sql file (MySQL) with its tables for different related matters. How can I extract the tables from an sql file, including a "master" ID column in all Tables, so that I can relate one table ...
0
votes
0answers
30 views
Difference between usr/local/mysql and mamp directories
Quick question about MySQL and MAMP
I am looking to get comfortable using MySQL, so I downloaded MySQL Workbench, and also MySQL package for OSX 10.6. I also have MAMP, which I use for testing my ...
0
votes
1answer
80 views
Can't start MySQL server on OSX
I just installed MySQL Server and Startup tools from the DMG at the MySQL site on an OSX 10.6.6. I restarted the computer, but it seems it can't connect to its socket.
$ /usr/local/mysql/bin/mysql
...
0
votes
1answer
19 views
What's the minimum requirement to run xdebug developement?
I've a very inexpensive virtual server but I get regular stuck in my developement with xdebug and Typo3 websites. Currently I'm running sshd, ftp, xdebug, mysql, postfix on my server and it's only for ...
1
vote
1answer
135 views
How to increase mysql max_allowed_packet for client?
I want to increase max_allowed_packet variable size for mysql client which is using remote server. I've googled it and the answers I could find only discussed changing the variable for server.
My ...
1
vote
1answer
69 views
How use windows command-line to run tools like SVN and MYSQL without going to theirs respective path [closed]
Possible Duplicate:
Adding an .exe to default path without adding the directory
What are PATH and other environment variables, and how can I set or use them?
Hi I would like to use ...
0
votes
0answers
32 views
How can I recover a non-dumped MySQL database from a previous Windows machine?
I recently replaced my Windows machine with a Mac. I backed up the entire hard drive of the Windows machine, but made the terrible mistake of not dumping the MySQL databases.
So I have MySQL up and ...
1
vote
1answer
50 views
Eclipse with JAR - Classpath on OpenSuse 12.1
howdy!
well i am brandnew to eclipse - i never ever used it so far!
i run a OpenSuse Linux Version 12.1 - and all works fine.
i am currently tryin to install the OSMGenerator - a tool that allows ...
-1
votes
2answers
70 views
Best AMP bundle for Windows (WAMPs)? [closed]
There's a list of WAMPs here:
http://en.wikipedia.org/wiki/Comparison_of_WAMPs
Which one is the best for PHP app development?
Do you know which one has the most complete set of PHP extensions?
1
vote
0answers
71 views
MySQL: how to restore from a previously saved copy of the data directory?
I have previously saved a copy of /var/lib/mysql/ddms directory ("ddms" is the DB name). Now I installed a new MySQL on a freshly installed Ubuntu 10.04.3 LTS by running apt-get install mysql-server, ...
1
vote
2answers
114 views
Removing MySQL completely on Linux
I'm fairly new to Linux, when I first installed MySQL it was during an LAMP setup on personal machine with a Ubuntu Setup. ATM, I'm trying to get a fresh, clean install of only MySQL. I've been to ...
0
votes
0answers
97 views
Could Jekyll/Octopress and other static blogging engines be a good option for a heavy online magazine? [closed]
I'm exploring several options for setting up a static blogging engine and migrating there some contents for some blogs I've got. I'd like to test the performance of these engines, and I've heard great ...
1
vote
1answer
123 views
Apache can't load dbi module in mac os x
I installed dbd:mysql via cpan. I have the following simple script:
#!/usr/bin/perl -U
use DBI;
$ds = 'DBI:mysql:project:localhost'; $user = 'root'; $password = '123456';
$db = DBI->connect($ds, ...
1
vote
2answers
121 views
mysql silent install and configure in nsi
i want to silently install MySQL 5.0 in NSI. I tried the following code in NSI:
ExecWait 'msiexec /i "$INSTDIR\mysql-essential-5.0.27-win32.msi" /qn'
ExecWait "C:\Program Files\MySQL\MySQL Server ...
0
votes
1answer
28 views
Any idea why I am getting this error trying to install Toad for MySQL?
I am trying to install toad for mysql and i am getting this error during installation. Any suggestion
0
votes
0answers
91 views
How to build mym (matlab to mysql) on 64-bit Windows 7
Has anyone been able to get mym (http://sourceforge.net/projects/mym/) to build on a 64-bit Win7 machine? And if so would you mind posting or linking your steps to do so?
My particulars:
Windows 7 ...
1
vote
1answer
16 views
transfer mysqld output to a text file
I tried the following in debian:
mysqld restart > mysqld.txt
But I can see nothing in mysqld.txt, while I can still see the output of mysqld restart on screen. I wonder why.
0
votes
0answers
51 views
how to install Mysql & tomcat on mac os x 10.5.8
Hi can some one provide me how to install both om my mac osx 10.5.8
Hi can some one provide me how to install both om my mac osx 10.5.8
Ok this what I have done
Downloaded MySQL version 5.5.22.dmg ...
1
vote
3answers
331 views
How do I log out of `sudo su` in Ubuntu?
I am semi-new to Ubuntu and I am using sudo su to start mysql and do some homework with it. When I quit mysql I then am still in sudo. How do I "log out", so my prompt changes back from # to $?
2
votes
2answers
76 views
How to connect MySQL database through two SSH hosts
How do I connect to MySQL database through two SSH hosts ?
Here is my situation: I have two SSH hosts as show below. MySQL is running in BOX2 host.
MyBox(GUI client) -----SSH(port 22)--->BOX1(IP: ...
0
votes
0answers
31 views
Looking for a good way to schedule MySQL updates from a Windows-based ODBC source
Am working with a propietary application that uses a dbisam database. We are looking to pipe scheduled updates from this source to a MySQL server (mostly likely on another box, but likely within the ...
1
vote
0answers
36 views
Quickest way to a minify a SQL file from the command line?
I want to run a single batch command that must take mySQLfile.sql and compress it by minifying it. Any suggestions on how to get mysqldump to produce the most compressed sql file would also be highly ...
1
vote
1answer
35 views
Change location of storing mysql database
Im running a linux server and I wondering if and how could I change the contents of Mysql server to be saved on an external hardrive instead of the place where it is being stored now.
0
votes
1answer
41 views
Issue changing mysql password on Debian
I installed mysql on my Debian server. I couldn't get into the database because it kept saying I put in the wrong password so I looked on the internet and found that I could log onto mysql using the ...
0
votes
0answers
69 views
How to generate MYSQLWorkbench formated XML with mysqldump
I am trying to create a script that automatically dumps xml from certain tables in the databases. The problem is we developed our xml parser around the XML format that MYSQLWorkbench uses when you ...
0
votes
0answers
162 views
mysql - Downgrade MySQL on Ubuntu 11.04
My company is upgrading an old project from Rails 1.2.3 to 2.3. I am trying to get another server set up that will host the original code and MySQL Database to keep track of how we are doing. However, ...
1
vote
0answers
16 views
MySql memory allocation
Anybody knows how MySql allocates memory for "text" and "blob" in case i'm inserting smaller data than the max size of the column ?
For example, What happens when i insert 50K string into a "text" ...
1
vote
1answer
70 views
\G like vertical output in MySQL Workbench for show engine innodb status
show engine innodb status; is unusable in MySQL Workbench, as shown here:
=====================================120329 12:39:32 INNODB MONITOR OUTPUT=====================================Per second ...
