Linux - SoftwareThis forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.
Notices
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
I need to know how to remove a variable from cmdline.
I don't know if that is the right name for it, and that is partly my problem.
There is a variable called binlog_expire_logs_seconds
I went to modify it, and I typed in binlog_expire_log_seconds
So I left of an s, and now I can't restart mysqld. Says it's unknown. So, I need to remove the variable(or whatever the correct term is). I just don't know the command, since I don't know the correct name, variable or is parameter or some other name!
I need to know how to remove a variable from cmdline.
I don't know if that is the right name for it, and that is partly my problem.
There is a variable called binlog_expire_logs_seconds I went to modify it, and I typed in binlog_expire_log_seconds
So I left of an s, and now I can't restart mysqld. Says it's unknown. So, I need to remove the variable(or whatever the correct term is). I just don't know the command, since I don't know the correct name, variable or is parameter or some other name!
No idea what you're talking about. What command line did you type in, where? What exactly did you do, how?? Because as you posted, it's impossible to figure out what you mean.
There is a variable called binlog_expire_logs_seconds
I went to modify it, and I typed in binlog_expire_log_seconds
So I left of an s, and now I can't restart mysqld. Says it's unknown. So, I need to remove the variable(or whatever the correct term is). I just don't know the command, since I don't know the correct name, variable or is parameter or some other name!
Thanks!
Where is this variable? Is it in mysql? In the OS? How did you try and modify it? What command was used? In the OS or when in the mysql environment?
We cannot guess what you did and my skills at mind reading are non-existent.
Well, that's about my ability with mysql!
It was in the mysql, I did this operation:
SET GLOBAL binlog_expire_logs_seconds= and set a time. The problem is I left off the s, at the end of logs.
It generally seems to be called a system variable. I need to remove the variable that is incorrect, binlog_expire_log_seconds
Ah, found where I could correct it. I didn't know it would end of sitting in the my.cnf but I found a clue pointing to it, and there it was. Makes me feel kinda dumb, but I am flying mysql blind.
If it was in my.cfg then it would seem to be a mysql variable and not a system variable.
I am glad you are working at using & learning about mysql. Actually using things (and often making mistakes then fixing them) is how I have learned most of my admin skills for linux, apache web server, mysql, AIX, and others. We learn as we do things.
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.