Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I have found the perfect way of doing it without any side affects and also works perfectly with xampp control panel...</p> <p>before you begin, make sure you backup your databases to files and also export all users to a file be sure to stop mysql there is no need to uninstall the service</p> <p>Step 1: Download the new version on MySQL install version or zip.(install version prefered since it is considerably smaller)</p> <p>Step 2: Install MySQL to C:\TEMP. Install only the MySQL server</p> <p>Step 3:Do not run advance options. do not let it install service. no configuration is required.</p> <p>Step 4: Go to C:\TEMP, look for installation and copy the following folders "bin, include, lib, share, support-files". be absolutely certain not to copy data Once copied, go to your xampp folder, rename mysql folder to mysql_old. create new mysql folder then paste the contents that were copied</p> <p>Step 5: Go to mysql_old and copy the data folder and paste it into your new mysql folder as well</p> <p>Step 6: go to the bin folder within mysql that is located within xampp and create a blank my.ini file. If you are upgrading to version 5.6.11 which is what I did, then all you have to do is write a few commands which I have at the bottom of this instruction</p> <p>step 7: click start next to MySQL on the xampp control panel and it should start normally assuming to you followed to instructions properly. Once done, you can uninstall the mysql package that you had installed to C:\TEMP Any questions or problems, message me or post back!</p> <p>BY WAY, the key is having a proper my.ini file</p> <p>here is mine:</p> <pre><code>[client] port=3306 socket="C:/xampp/tmp/mysql.sock" [mysqld] port= 3306 socket = "C:/xampp/tmp/mysql.sock" pid_file = mysql.pid skip-federated explicit_defaults_for_timestamp basedir="C:/xampp/mysql" datadir="C:/xampp/mysql/data" tmpdir = "C:/xampp/tmp" log-output = FILE log-error = mysql_error.log general-log general_log_file = mysql_general.log slow-query-log slow_query_log_file = mysql_slow.log default-time-zone = -5:00 long_query_time = 2 plugin_dir = "C:/xampp/mysql/lib/plugin" server-id = 2 #ft_stopword_file = "C:/xampp/mysql/bin/mysql_ft_stopword_file.ini" ft_min_word_len = 3 ft_max_word_len = 50 character-sets-dir = "C:/xampp/mysql/share/charsets" character-set-server = utf8 collation-server = utf8_unicode_ci innodb_ft_max_token_size = 50 innodb_ft_min_token_size = 3 innodb_ft_enable_stopword = off key_buffer_size = 8M query_cache_type = 1 query_cache_size = 4M query_cache_limit = 4M default-storage-engine = InnoDB [mysql] default-character-set=utf8 </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POXAMPP USB Lite - How to change or upgrade MySQL 5.5 to 5.6?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USSeul Shahkee
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POXAMPP USB Lite - How to change or upgrade MySQL 5.5 to 5.6?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload