• The new Python extension is now available. It allows customers to deploy and manage WSGI-based Python applications on their websites directly from Plesk.
  • The Plesk Mobile apps for iOS and Android and the Plesk Mobile Center extension have been deprecated, and are no longer available for new installations. In Plesk Obsidian 18.0.84, the Plesk Mobile Center extension will be removed from servers during the upgrade, and the Plesk Mobile apps will lose their server management features.
  • The Social Login extension has been deprecated and will be removed in Plesk Obsidian 18.0.84. After that, it will no longer be possible to log in to Plesk with a Google, Facebook, GitHub account, or with a passkey. Plesk usernames and passwords, as well as logging in with a WebPros Account, are not affected.

Question MySQL Database

Tim Clarke

New Pleskian
I am trying to set up a MySQL database. I am running:

OS ‪CentOS Linux 7.6.1810 (Core)‬
Product Plesk Onyx
Version 17.8.11 Update #54, last updated on May 25, 2019 12:54 AM
MySQL Version 5.5.60

The data is in an Excel Spreadsheet, which I am importing as an ODS file. Everything seems to load in fine, except for the column which contains website links. For some reason, this column is entirely empty apart from the header itself and, for some reason I cannot fathom, one website link! I have tried with and without the starting "http://" and this has made no difference.

I would be grateful for any help.

Many Thanks in advance
Tim
 
My first guess would be that you're dealing with a character encoding issue or a delimiter issue.

What procedure are you using to convert / import the ODS?
 
Thanks. It is an Excel spreadsheet that I am simply saving in ODS format. I am using the latest version of Excel.

I am importing through phpMyAdmin; Import; see screen print attached.
 

Attachments

  • SQL Import.jpg
    SQL Import.jpg
    141 KB · Views: 5
Back
Top