MySQL Server

47K

Solutions

23K

Contributors

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

Share tech news, updates, or what's on your mind.

Sign up to Post

Hi all i have installed Ubuntu server on a azure VM and opened port 3306 but cant seem to connect to my myphpadmin or sql server remotely i have also turneed of the firewall on the server to confirm this is not a issue, any help would be great
0
11/26 Forrester Webinar: Savings for Enterprise
11/26 Forrester Webinar: Savings for Enterprise

How can your organization benefit from savings just by replacing your legacy backup solutions with Acronis' #CyberProtection? Join Forrester's Joe Branca and Ryan Davis from Acronis live as they explain how you can too.

I want to install MySQL database server on RHEL 5.7 Virtual machine.

I want to test exporting large oracle tables from oracle DBMS server 12.2 into MySQL tables.

1) How long does it take to download, install and configure the server?

2) Do I need to download the free community server or enterprise server for the export oracle data test?

3) Which site do you normally use to download software?

Thanks,
0
We are using MariaDB at work and I have been asked to create a query that would involve counting the number of a particular string in a column.

table sumDataContent
The table sumDataContent has a text column with HTML in it.
I have been asked to display all the Ids that have 1 or 2 <blockquotes> in it.

My query:

SELECT dataId, SUM(blockquoteCounts)
FROM (
	SELECT dataId, LENGTH(sumDataContent.textHTML) - LENGTH(REPLACE(sumDataContent.textHTML,"%<blockquote>%","")) AS COUNTS
	FROM sumDataContent) AS blockquoteCounts
GROUP BY dataId

Open in new window



Unfortunately, this doesn't work.

Can someone give me an idea of what I'm doing wrong?

Thanks

Massimo
0
Hi,
I set up MySQL57 (version 5.7.28), and where can I get same file (in 32-bit) for file below

C:\Program Files\MySQL\MySQL Server 5.7\lib\libmysql.dll

How to verify MySQL 5.7.28 is fine, after the setup?
0
Hi Guys,

We have moved to a new web server (Windows 2016) 32gb RAM and its seems to be slower even though it has twice the resources.

I was wondering can i check if the PHP and  MySQL is set up correctly. It looks like the PHP + MySQL read/write is slower than the previous server. Probably some of the MySQL setting needs to be changed?

What would be the best place to start?
0
hi laravel project not starting in browser localhost/cms/public/
Installing laravel/laravel (v5.2.31)
  - Installing laravel/laravel (v5.2.31): Loading from cache
Created project in cms
> php -r "copy('.env.example', '.env');"
Loading composer repositories with package information
Updating dependencies (including require-dev)
Package operations: 58 installs, 0 updates, 0 removals
  - Installing kylekatarnls/update-helper (1.2.0): Downloading (100%)
  - Installing symfony/polyfill-ctype (v1.12.0): Downloading (100%)
  - Installing vlucas/phpdotenv (v2.6.1): Downloading (100%)
  - Installing symfony/polyfill-mbstring (v1.12.0): Downloading (100%)
  - Installing symfony/var-dumper (v3.0.9): Downloading (100%)
  - Installing symfony/translation (v3.0.9): Downloading (100%)
  - Installing symfony/routing (v3.0.9): Downloading (100%)
  - Installing symfony/process (v3.0.9): Downloading (100%)
  - Installing symfony/polyfill-util (v1.12.0): Downloading (100%)
  - Installing symfony/polyfill-php56 (v1.12.0): Downloading (100%)
  - Installing psr/log (1.1.2): Downloading (100%)
  - Installing symfony/debug (v3.0.9): Downloading (100%)
  - Installing paragonie/random_compat (v1.4.3): Downloading (100%)
  - Installing symfony/http-foundation (v3.0.9): Downloading (100%)
  - Installing symfony/event-dispatcher (v3.4.35): Downloading (100%)
  - Installing symfony/http-kernel (v3.0.9): Downloading (100%)
  - Installing symfony/finder (v3.0.9): Downloading (100%)
  - Installing 

Open in new window

0
hi,

 I am checking MySQL support life cycle and what I get is :

Oracle lifecycle support is mostly consistent with all products.  MySQL is one of the product lines.
Premier Support is 5 years after the product GA.  thereafter 3 years for Extended and thereafter for Sustanining.   This is generic to all Oracle Product - not just MySQL.

http://www.oracle.com/us/support/library/lifetime-support-technology-069183.pdf


Also with the "Premier", "Extended" and "Sustaining" Support , you can refer to the definition as follows :
https://www.oracle.com/support/lifetime-support/


for sustaining support from the URL https://www.oracle.com/support/lifetime-support/, what is pre-existing means ?

usually what is the different between extended and sustaining in terms of pre-existing items?
0
hi which php framework i can use to develop ecommerce application like amzom
0
I'm currently looking at massive scaling challenges

I need a database system that supports the following

here are my requirements
1) High insert rates for timeseries data (60,000 records per second - could be batch inserted)
2) NewSql style database (not NoSql)
3) One main table takes the LOG data, the rest are things like users etc that I need to join to the LOG table, therefore i need full SQL support
4) be able to scale horizontally and also put different months data on different servers so I dont run out of diskspace (currently its all on one large disk)
5) where possible just throw new hardware at the database and it work
6) support OLAP and OLTP work loads - i.e. high insert rates, and reporting (ideally under one system)
7) Open source / free

I've looked at:
Postgres & Citus
MemSql
Vitess

I'm wondering if anyone has any input or experience that could help recommending a good option or considerations
0
hi,

I just upgraded the MySQL 8.0.12 to 8.0.18 and the upgrade process is good! my company install MySQL generic binary .

After upgrade I found out one problem, I upgrade all slave first then finally primary DB server and this procedure is normal

When I upgrade the primary one the RW roles goes to other  nodes,  from cluster.status() primary one is missed , which is normal as I am upgrading primary nodes.

Once I bring primary back, primary become new primary again, but the nodes failovered to before also STILL primary! later on cluster status() will say 2 x slave node is MISSING without any reason, ONLY the primary left!

cluster status
I can only bring all the slave node back again by using:

mysql > set persist group_replication_start_on_boot=ON;
mysql > shutdown
start mysql again.


any reason for this failover problem? this is all online before and 2 x down JUST BECAUSE of 1 failover ?

how to fix it ? in my.cnf ?

this is my exsting my.cnf:

my.cnf
0
How to Generate Services Revenue the Easiest Way
How to Generate Services Revenue the Easiest Way

This Tuesday! Learn key insights about modern cyber protection services & gain practical strategies to skyrocket business:

- What it takes to build a cloud service portfolio
- How to determine which services will help your unique business grow
- Various use-cases and examples

hi,

how to use the --relay-log option and  --relay-log-index option with MySQL for  replication ? I just upgraded my MySQL from 8.0.12 to 8.0.18 and it seems it is the improvement 8.0.18 suggest me to implement so that replication is not going to break when the node I am upgrading is a slave.
0
hi

I have a wordpress site which was previously running on Apache and MYSQL.

I have had to move the site onto IIS7.5 with MySQL for Windows.

The site is running and the wp-admin area is fine but when ititially loading the site its taking approx 10 seconds to display the page, even locally on the server.

Once the site has loaded to seems to function ok.

Any idea?

thanks
0
Hi,
I did no change but now I cannot access Mysql below. Why?
 45x.png
And how to resolve error below?
45y.png
0
Hello. I create a Mysql database and a table on a web hosting company server. but I do not have an idea, How to verify connection and  bring a record or value from Mysql database. Can someone write a simple php code for me? I have following information. for example, Server IP address- 1.1.1.1, Database name-tempdataserver, Database user ID- tempuser, Password- temppaass.
Primary key column- stock, Primary key example- aapl, Column to display- CLOSE.

I  can connect  use Mysql for Excel and make a new table.
Thank you.
0
Hi

I have a SQL Server table with a varbinary-field in it. I want to insert that record in a MySQL-Database. How can I access this field-data?
myTable is local on a SQL Server
mySqlTable1 is on a MySQL Server in the web

Query1.SQL.Text := 'SELECT myString1, myVarBinary1 FROM myTable';
Query1.Execute;
mySqlQuery1.SQL.Text := 'INSERT INTO mySqlTable1 (str1, blob1) VALUES('+QuotedStr(Query1.FieldByName('myString1').AsString)+','+??myVarBinary1??)'

Open in new window

How can I access the varbinary-field? Something like Query1.FieldByName('myVarBinary1').As???
Thanks for any help
Peter
0
I'm having trouble with a MariaDB nested correlated subquery.  I need to reference a returned rowcount as a column value that is dependent on a customer id from the parent query.  The problem I'm having is MariaDB / MySql has a limitation that only allow correlated queries 1 level deep.  The COUNT portion of the following query violates that rule.  I'm guessing this could be accomplished using JOINs instead, but I'm really at a mental roadblock and could use some fresh eyes.  HELP PLEASE!

SELECT t.*,

#This is the count that I need to have returned as a value
(SELECT COUNT(MERGEDVAL)
FROM (SELECT
CONCAT(sos_deliverydate,
               sos_trip_id,
               sos_route_id,
               sos_routestop) AS MERGEDVAL
        FROM   salesordersummary s2
        WHERE  0 = 0
               AND ( sos_deliverydate BETWEEN '2019-08-18' AND '2019-09-14' )
               AND sos_shipvia <> 'SLS DEL'
               AND ( sos_shipvia <> 'T2'
                      OR Dayofweek(sos_deliverydate) = 1 )
               #this is the referenced value that I need to use.  This works well if I manually fill in a value for 't.sos_customer_id', but fails otherwise
               AND sos_customer_id = 't.sos_customer_id'
        GROUP  BY sos_deliverydate,
                  sos_trip_id,
                  sos_route_id,
                  sos_routestop) AS DROPS) AS DROPCOUNT

FROM (SELECT sos_salesperson_id,
       sos_customer_id,
       …
0
I have installed VtigerCRM and started working.
I changed from http to https but site not opening after that.
Capture43.JPGI have a certificate ready but dont know where is the certificate location.
I followed as per this article
https://www.fastcomet.com/tutorials/vtiger/enable-ssl
0
hi my xampp not starting in browser
xampp
0
I have a database running on CentOS 7, MySQL 5.1.  

My question is that the general log file is like 10 - 20 GB a day and is full of simple select statements.  Is this normal?  That seems to be a huge daily file to create.  I am pretty new to MySQL on CentOS so was hoping someone could tell me if that seems to be a bit much or if it is pretty normal?

Thanks!

Jim
0
C++ 11 Fundamentals
LVL 19
C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

hi am geting this error trying to start mysql database in ubuntu

mysql -u root -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
user@myubuntu:~$ sudo etc/init.d/mysql -root -p start
[sudo] password for user:
Sorry, try again.
[sudo] password for user:
Sorry, try again.
[sudo] password for user:
sudo: 2 incorrect password attempts
user@myubuntu:~$ sudo start mysql
[sudo] password for user:
start: Unable to connect to Upstart: Failed to connect to socket /com/ubuntu/upstart: Connection refused
user@myubuntu:~$ Unable to connect to Upstart: Failed to connect to socket /com/ubuntu/upstart: Connection refused^C
user@myubuntu:~$ ^C
user@myubuntu:~$ sudo etc/init.d/mysql - root -p start
sudo: etc/init.d/mysql: command not found
user@myubuntu:~$ sudo etc/init.d/mysql -root -p start
sudo: etc/init.d/mysql: command not found
user@myubuntu:~$ sudo /etc/init.d/mysql - root -p start
Usage: /etc/init.d/mysql start|stop|restart|reload|force-reload|status
user@myubuntu:~$ pswd
123456: command not found
user@myubuntu:~$ sudo /etc/init.d/mysql - root -p start
Usage: /etc/init.d/mysql start|stop|restart|reload|force-reload|status
user@myubuntu:~$ sudo /etc/init.d/mysql start
[....] Starting mysql (via systemctl): mysql.serviceJob for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.
 failed!
0
hi,

Now I have convert Oracle to MariaDB/MySQL and we have a convern, how can we know the number of table is the same! but the main idea should be what tables is missed from MariaDB/MySQL side?

any easy way to compare what table is missed on MySQL/mariaDB side ?
0
We use SQL server 2017 as our main data store RDMS

We have a vehicle tracking app with one massive log table (all positions for vehicles)  and a lot of other small tables (like car number plate, users etc), pretty much every query involves a join to this main log table
We are just getting going, and the main table is over a billion rows and over 1TB with a relatively small number of cars in relation to the growth plans for the next year
I know this is small, but we estimate we will grow between 10x to 100x in the next year, which has brought up some architecture questions for long term.

Currently we use SQL server which runs nicely, we will also be adding redis to address reduce load on DB,
Currently the DB grows by 10GB every day
Considering we maybe growing at least by 100GB a day, over time this puts us into the BIG DATA category, and I need to start looking at some options for scaling
Every record that gets inserted to the log table gets an ID, and we use this ID for logging events, alerts etc for fast performance (this works well at the current sizing)

Currently my biggest headache is servers with disk storage, I can find server options upto 10TB quite easily, but after this options are limited and prices sky rocket.
Pricing is a massive issue, we are not Google/Microsoft and cannot afford huge server costs.
Performance is also a huge issue, for example, people expect to run reports and expect very small loading times.
We were also planning to move …
0
Hi Experts,
I would like to extract the pay_interval field value from the JSON array into MYSQL syntax :
[
  {
    "111_id": 238777,
    "222_no": "I-86605",
    "333_item": [
      {
        "444": "Contract Rate",
        "555": "Hours",
        "666": "210.00",
        "777": "12.00",
        "888": "17.50",
        "999": "42.00",
        "2222": "252.00",
        "3456": "1234invoice_no": "INV-1",
        "54345": "90"
      }
    ],
    "pay_interval": 1,
    "888": "Unpaid",
    "t999": 210,
    "000_id": 29669,
    "234_id": 4393
  }
]

Open in new window

Any help would be appreciated
Thanks
0
hi,

right now I tried to do a logical backup from MariaDB 10.4.7 to MySQL 8.0.17 and I use mySQLdump:

Mysqldump  --databases <my database>  --single-transaction --user=root --password > <my database>.sql

Open in new window


dump is ok but I keep finding table schema dtail is missing, like constraint is not in the sql,  view, trigger and function also missing, how can I use mysqldump to dump all logical information to the output so that the script will create everything of that database for me?
0
To enable binlog in percona cluster we need to add variables to my.cnf, where we need to add server-id and log-bin

As per percona documentation they recommend PXC nodes share the same server-id.

Does this mean if we have 3 nodes in the cluster should we keep as server-id=1 for all three nodes?
0

MySQL Server

47K

Solutions

23K

Contributors

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.