MySQL Server

47K

Solutions

22K

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,
Joomla fronted show this error but backed is working fine. i don't understand  what is the issue.

1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-08-21 10:4' at line 1

Open in new window


Please help me.
Thanx
0
Get your problem seen by more experts
LVL 12
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

hi,

this is the first time I install MySQL  enterprise 8 and it is very different from what I install MySQL 5.7.19 before,both using generic binary before by extracting Tar.

hi,

Right now trying initialize the mysql enterprise 8 with a my.cnf of this content:

[client]
socket = /POC/mysqlserver8/data/mysql5719.sock

[mysqld]
server-id = 3

auto-increment-offset= 3    

auto-increment-increment=10  

log-slave-updates = ON
socket = /POC/mysqlserver8/data/mysql5719.sock
port = 3306
basedir = /POC/mysqlserver8
datadir = /POC/mysqlserver8/data
log_bin = mysql-bin
innodb_flush_log_at_trx_commit=1
sync_binlog=1
binlog_do_db = sample
bind-address    = 0.0.0.0       #connection from all IPs allowed

general_log = 1
general_log_file = /POC/mysqlserver8/mysql_general.log



slow_query_log = 1
slow_query_log_file  =  /POC/mysqlserver8/slow_query.log

log_error = /POC/mysqlserver8/MySQL_error.log

log_queries_not_using_indexes = 'ON'
log_syslog = 1


1) Once  initialize it by using bin/mysqld --defaults-file=my.cnf --user=mysql  --initialize, I  don't see this file exist: /POC/mysqlserver8/data/mysql5719.sock, any problem of it ?
2) once initialize, it return no message to me but the data folder has a lot of file generated which means the process worked, but when compare to the MySQL setup I did before, there should be a temporary password generated by this process, any problem with it?
3)  when login using root account to try the …
0
I have MySQL 5.6 community server on Windows. How to configure so that Workbench and .Net Web App client  can use SSL to connect to the MySQL server?
0
hi all,

Any known problem on  MariaDB to work with MySQL Enterprise and MySQL community?

what need to setup so that they all work together well ?

we are considering to save cost on, e.g. only some of them are MySQL Enterprise and the rest are MySQL community/MariaDB.

any idea?
0
Dear Experts,

I am currently experiencing data loss issues on magento table (name  catalog_product_entity_group_price) .
After the insert and check with the count command, the record is still sufficient. But after a while, especially when running price index script, I check the that table again, some record rows are disappeared.

Please help me, why Mysql DB Table Rows Disappearing, other reason can cause row loss in mysql ?

Thanks!
0
Hello Experts,
Just wondering if there is a any opensource JAVA JAR file that I can use for a project that allows me to connect to a DB (like mysql or H2), create tables, insert data into tables, etc. Basically, I am looking for a solution which builds the queries itself when data is passed as parameters to a method. Any inputs really appreciated.
0
Hi Expert(s),

Is there a way to write Data (eventually with SQL)  from the AS400-DB2 to a MySQL-DB or Oracle?
0
hi,

any clear to understand and follow installation guide to quickly setup MySQL InnoDB cluster? 3 x DB  node and 1 x nodes for MySQL router and MySQL Shell ?

we are told to use InnoDB cluster but not NDB cluster.


test guide are also good.
0
Hi,
suppose i have a mysql table  with rows (originalUrl : varchar(500) , shortUrl : varchar(10))
The queries that will be executed on this table will mostly be
1. select * from table where shortUrl = X
2. insert into table (originalUrl, shortUrl)

So there should be an index on shortUrl to speed this up.

I have the following question -
1. What exactly the index table will store ?
My understanding is index table will store items like - (shortUrl, pointerToDisk) // where pointerToDisk will locate exactly the place in disk where the row is stored.

2. Where is index table stored ?
Is it always stored in Disk or memory ?

3. What is the size of index table exceeds that of RAM ?
In this case the full index table will never be in RAM and so how will queries like select * from table where shortUrl = x execute
Will a part of index table be pulled out everytime to check the location ?

4. In case where this table is very huge say 3 TB. How big will index table be...

5. If index table is larger than size of RAM and since then the queries will take a lot of time. Is there a better alternative ?? Like using noSQL database. or storing data in two machines splitting them rather than on one machine ?

Thanks
0
I have a wordpress website with thousands of custom posts.  I'd like to be able to edit them and/or bulk create new custom posts by inputting information into something like a spreadsheet broken down by field.

I've tried the WP-CSV plugin and it did work for bulk editing and post creation until the site got too big (memory issues I believe).  

Is there a plugin that might work for this application, or is this best as a mysql operation (I don't know mysql).

Thanks!!
0
Keep up with what's happening at Experts Exchange!
LVL 12
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

MySQL installation issue..I'm trying to install MYSQL via MSI installation for windows. The configuration doesn't start the server and ends withe the following error

Waiting 3 seconds before the next connection attempt...
  Retry 3: Attempting to connect to Mysql@localhost:3390 with user root with no password...
MySQL error 0: Reading from the stream has failed.

However i couldn't able to skip without a password in the wizard.

Please let me know how to fix this problem
0
Hi,
I am planning to build a service like shortening url for learning purpose..I was working on it theoritically.
And realized that i would be needing to store approximately 32 GB of data in the long run...
It will be mostly key value pair data  
eg -
1) www.bity.com/abcdefg  |  www.klasjlkajsf.comalskdfjlaksdjflkasjdfl
2) www.bity.com/abcdefg  | www.laksdjflkasjdflkasd.aldskjflkasdjflkasdf//alsdkfjalsdfj

So i was wondering which database will be better.
Dont know how Mysql will behave when total data reaches 32 GB ?
How long will it take to query it..
Is there some theoritical way to find it out. I think putting an index on the first column should be really fast kind of binary search ?
What are the alternatives  or best way ?
I read about redis that seems to be an in memory database so should be really fast. But it probably cannot store more data than the amount of RAM.
is redis feasible when the amount of data is so big like 32 GB ?
Do we need 32 GB of RAM or there are alternatives ??


Thanks
0
How I can I update a value I got from an Select query?

Sample: Update mytable1 Set my mytable1.value = (Select value from mytable2 where mytable2.id=1) where mytable1.id=1
And do not want to select. put in to a variable and write back to the db.

I use a MySQL Database on Linux.
0
In Below Scenerio, Will Master-slave replication should work?

I have local and live Server. Everyday i have to insert data from local machine which needs to be synced to live Server(1 time per day) and changed data needs to be sync back to local.
0
I have a MySQL database. Can anyone help me on how to auto increment a column in which is an integer? I am totally new to databases

An increment is a 7 digit number and it has to custom auto increment

CREATE TABLE `march13airtelvd` (
  `id` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `country_id` int(50) NOT NULL,
  `operator_id` int(50) NOT NULL,
  `os` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `testType` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `placeType` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `performanceType` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `technologie` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `dateTest` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `testValue` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `lat` double NOT NULL,
  `lng` double NOT NULL,
  `nameCity` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `id4gmark` int(10) NOT NULL , (This column has to be in auto increment which starts from "1100000")
  `source` varchar(50) COLLATE utf8_unicode_ci NOT NULL

)
0
Hi,

Now our MySQL cluster test platform do not have internet connection and we need to setup local repository for it.

I check out a lot of googled page and it seems no one exactly match what I am going to install, let see what I go from latest MySQL cluster 7.6.6 binary:

rpm files list.
so for management node, which rpm I should install and what is the command for it? just yum --noplugin localinstall <rpm name> ?

For data node, which rpm I should install?

For SQL  node, which rpm I should install ?
0
Goal: Toggle sorting a column of dates in descendingascending order including the entire row in a table. The in-page PHP currently sorts some columns. We need to add sorting for all columns in the table. I tried applying the same input tag format to two columns that were not set to sort. Specifically, the Commissions and Referrals columns will not sort when applying the same input tag format as other columns that sort correctly. Both buttons throw the following error: Unknown column 'Agent_Commission' in 'order clause'
agent_page8-test.php
0
hi,

As our test platform do not have internet access to let yum install download all rpm and dependency, we are check if it is possible for us to add internet access for all test machine for us to download MySQL cluster binary and install it successfully with yum install, what is the URL for Yum to work ?

repo.mysql.com

?
0
Guys how can I add username already exist on this error handler?... I already have for email but don't know how to add username
here is my code
<?php
require_once 'db.php';

if($_POST)
{
    $username      = ($_POST['username']);
    $email     = ($_POST['email']);
    $password  = ($_POST['password']);
    $joining_date   = date('Y-m-d H:i:s');
    $password   = password_hash( $password, PASSWORD_BCRYPT, array('cost' => 11));
	
///Start of second try    
    try
    {
        $stmt = $connection->prepare("SELECT * FROM users WHERE email=:email");
        $stmt->execute(array(":email"=>$email));
        $count = $stmt->rowCount();
        
        if($count==0){
            $stmt = $connection->prepare("INSERT INTO users(username,email,password,joining_date) VALUES(:uname, :email, :pass, :jdate)");
            $stmt->bindParam(":uname",$username);
            $stmt->bindParam(":email",$email);
            $stmt->bindParam(":pass",$password);
            $stmt->bindParam(":jdate",$joining_date);

            if($stmt->execute())
            {
                echo "registered";
            }
            else
            {
                echo "Query could not execute !";
            }

        }
        else{

            echo "1"; //  not available
        }

    }
	///End of first try
    catch(PDOException $e){
        echo $e->getMessage();
    }
}
?>

Open in new window

0
Cloud Class® Course: Amazon Web Services - Basic
LVL 12
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

I have a linux site. I create a cvs file no broblem

Thing is i write to /var/lib/mysql-files

I need acces to those csv files via  browser

folder is /var/www/html but I cant write to it (The MySQL server is running with the --secure-file-priv option so it cannot execute this statement)

What can I do and how?

Grant access so I can write to /var/www/html  (Dont know how)

Or Browser access to  /var/lib/mysql-files.  I tried with a symbolic link. No luck

Any ideas?
0
We have to serve 50,000,000,000 requests per day, our app can handle that, but we're not sure if our database skills are there to pick this up. We have a database server with 256gb of ram and 512GB SSD RAID using percona edition. Some of the data needs to stay on the database for 30 days, the transaction table where all requests are stored. what approach do we need to scale this horizontally? each endpoint requests runs about 4 queries...
0
hi,

I am setting up the first MySQL cluster and I need to install the auto install rpm first, but that one said it depends on community server rpm first, which asking for the client to be install, but when I install the client it complain:

when installing MySQL client
so how can I get ride of that error when installing the client?

what is perl (Class::MethodMaker) ? how to install it?

I download all component from https://dev.mysql.com/downloads/cluster/

and now the files list is:

MySQL  Cluster binary downloaded.
anything missed?
0
Hello! I'm trying to make my first web application of a hotel(this is an education project not a payed one) and I have a lot of issues...The most important one is that if a user at the registration process selects that he wants to reserve 4 rooms he needs to make the checkin process 4 times, once for each room. I have succesfully managed to register the user and login, but the problem is with showing the check-in form for a number of times... I managed to show it once, but the second time it doesn't work, it shows me the details for the same room, not for a different one, or it makes an infinite loop...what can I do? Here it's the PHP code:
<?php
	ob_start();
	 $success = false;
	// Errors reporting, used if needed
	error_reporting(E_ALL);
	ini_set('display_errors', 'on');

	// General configuration like base, used if needed
	include_once ('include/config.inc.php');

	// Mail functions
	include_once ('include/mail.functions.php');



	// DBConn
	include_once ('class/DB/DBConn.includeall.php');
	$db = new DBConn(NULL);

	// Includere clasa login
	require_once ('class/class_login.php');

	// Set up current language
	$lang = "ro";
	$_SESSION[PRE.'lang'] = $lang;
	$row='';
	$access = 0;
	$user = (isset($_POST['nume']) && !empty($_POST['nume'])) ? $_POST['nume'] : "" ;
	$email = (isset($_POST['email']) && !empty($_POST['email'])) ? $_POST['email'] : "" ;
	$telefon = (isset($_POST['telefon']) && !empty($_POST['telefon'])) ? $_POST['telefon'] : "" ;
	$cnp = 

Open in new window

0
What is wrong with my mysql query?

select * into OUTFILE '/home/galaplas/public_html/seminario.com.mx/descargas_parquev/TD2489DAA2C294F9092B9207298A46527717201840949PMx.csv' FIELDS TERMINATED BY ',' LINES TERMINATED BY'\n' from (select * from TD2489DAA2C294F9092B9207298A46527717201840949PM order by estado,armadora,vehiculo,modelo) as temp

Table exists user password database connected ok executed in phpmyadmin

I need to write the csv  file in the /descargas_parquev/ folder
0
I am trying to select a value from dropdown list and insert into mysql database, i am new to PHP and i know my code is not pretty but i want to learn, please steer me in the right direction. Thank You.

<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title></title>
</head>

<body>

<form method="post" action="">
 
 <label >Please Select Username</label>
 
 <select name="checkin">
<?php
 require('db.php'); 

$sql = mysqli_query($con, "SELECT * FROM users LEFT JOIN check_in_out on users.id = check_in_out.check_id WHERE check_in_out.check_id IS NULL");
while ($row = $sql->fetch_assoc()){
echo "<option value=\"checkin\">" . $row['id'] . "</option>";
}

 ?>

</select>

 <button type="submit" name="submit" >Submit</button>
 


<?php
 require('db.php'); 
if(isset($_POST["submit"]))
{
 
$check_id ='check_id';
$check_in_date = date("Y-m-d H:i:s");
$sql =  "INSERT INTO check_in_out (check_id,check_in_date) VALUES ('$check_id','$check_in_date')"; 
$result = mysqli_query($con,$sql);

    echo "You are checked in";
}

 ?>
  </form> 
</body>
</html>

Open in new window

0

MySQL Server

47K

Solutions

22K

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.