Workbench MySQL Enterprise Backup Error

Hello all, I have not run across this problem where Workbench will not let me access the "Online Backup" link and claims that my version of MySQL Enterprise Backup is 0.0.0 (it is 4.0.0). I had backups running and scheduled through Workbench previously. Yesterday I changed my data files to

Re: mysql\innodb_table_stats.ibd. Cannot open tablespace

Hi Neil, When you say you delete the current database, do you mean the database files only? Are you doing a complete restore? On Fri, Jan 22, 2016 at 1:23 PM, Neil Tompkins wrote: > Hi, > > Hoping someone can help me identify why I keep having to restore my >

Re: mysql dump global read lock

Artem, You have --add-locks listed which will run LOCK TABLES prior to each table dump. --single-transaction is for InnoDB tables and ensures that they are copied in a consistent state. I hope this helps! On Thu, Dec 17, 2015 at 4:24 PM, Artem Kuchin wrote: > Hello! > > Hereis

Question!

resources or books that might help me that would be great. Thank you Yours Faithfully, Lisa Mannion, JS MSISS Student, Trinity College Dublin. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Unicode help

command in SQL that uses them. THANKS! Lisa N. Michaud, Assistant Professor of Computer Science Department of Mathematics and Computer Science, Wheaton College [EMAIL PROTECTED] http://cs.wheatoncollege.edu/lmichaud -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

INSERT using Unicode strings

the characters are specified? Thanks! Lisa N. Michaud, Assistant Professor of Computer Science Department of Mathematics and Computer Science, Wheaton College [EMAIL PROTECTED] http://cs.wheatoncollege.edu/lmichaud -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Load data infile...

?? thanks, i'd appreciate the help regards, Lisa _ Fynda på nätet! Handla på MSN Shopping http://www.msn.se/shopping - Before posting, please check: http

foreign key constraint to itself

Hi, I am just wondering can I create foreign key constraint to itself in mySQL innodb (the mySQL 3.23.50 release)? Let's say we have a table: test_table_01 (id integer, pid integer) type = innodb. Can I create a foreign key on pid and reference to test_table_01 (id)? Thanks, Lisa

foreign key constraint to itself

Hi, I am just wondering can I create foreign key constraint to itself in mySQL innodb (the mySQL 3.23.50 release)? Let's say we have a table: test_table_01 (id integer, pid integer) type = innodb. Can I create a foreign key on pid and reference to test_table_01 (id)? Thanks, Lisa

SQL not working, but no error messages...

, if you really think it's a problem on my end, I will work with someone individually and give copies of my code. Thanks! Lisa - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Re: SQL not working, but no error messages...

Okay - that was silly of me. I was checking the return values of the insert and the select, but I never did one for the connect. It's failing on the connect - I'm assuming that all I have to do is ask them what the proper way to connect to their database is. Thanks for your help! Lisa

I deleted my root user!

Please help. I accidentally deleted the root user and now I can't do anything. How can I recreate this user with super user privileges? I'm new to MySQL so please be detailed. Thanks in advance Lisa - Before posting

Opportunity of a Lifetime!! - adv

Dear Friends Future Millionaire: AS SEEN ON NATIONAL TV: Make over half million dollars every 4 to 5 months from your home for an investment of only $25 U.S. Dollars expense one time THANKS TO THE COMPUTER AGE AND THE INTERNET ! == BE A

Remote connect failure

in the user table are identical except for the host field. Thanks in advance, Lisa - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

load large data files?

the server. Lisa [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED

Switching SQL Databases

the article, please email me at [EMAIL PROTECTED] Thank you for considering this, Lisa Nadile __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com