How do I import database data to a new host that runs a newer version of MySQL without ssh access?

My current host for an old website has only MySQL 5.0 (serverVersion=10.2.12-MariaDB-log).

I want to move this website to a host that has either 5.5 or 5.6 or 5.7 MySQL (depending which server I move to).

But the only instructions I can find for updating database data from 5.0 to 5.6/5.7 are run from the command line, requiring ssh access that I do not have.
For example these are the best, clearest instructions I have found, but I cannot use them because, as AFAIK, I do not have ssh, nor do no fully understand the references ([he?] makes. (e.g. he says --no faults “for simplicity” but even if I had ssh, I don’t know if I should also use that flag or others.)

  • http://mysqlserverteam.com/upgrading-directly-from-mysql-5-0-to-5-7-using-an-in-place-upgrade/
  • https://mysqlserverteam.com/upgrading-directly-from-mysql-5-0-to-5-6-with-mysqldump/

I usually use MySQL Workbench to connect to remote databases, but when I connect to that old host via MySQL Workbench, a message pops up saying [Workbench] is not compatible with 5.0.
So for that host, I have either used MySQL Workbench anyway to make a backup (which probably probably means the backup is no good), or I use the host’s web-based tool (not my preference, but obviously better). I have also recently installed HeidiSQL because it seems to be compatible with 5.0 (I does not give a warning/error message anyway). So I have started making backups and minor data changes on that host using HeidiSQL.

The only reason I have continued to use the host running MySQL 5.0 is because I haven’t yet found instructions on how to migrate data for websites on that server, whether it’s via a hosting provider’s online database tool, MySQL Workbench, or HeidiSQL !
Everything I see is for for doing step-wise data upgrades using the command line, and/or for upgrading the database server itself.

I need a way to upgrade the data from 5.0 to 5.6 or 5.0 to 5.7, probably in 1 step, using a gui database connection tool, or some other independent method. I will not have access to any mySQL servers other than the server I’m migrating away from (5.0), and the server I am migrating to (5.5 or 5.6 or 5.7).

Does anyone know how to do this?

EDIT:

  • I usually choose “Export” from the gui to export and choose all tables, when I do a database backup. I assume this is the same as a “database dump” that I see referenced everywhere.
    Is this correct? If not, how do I generate a proper dump file?
  • What export “settings” should I use when the goal is to upgrade and migrate?
  • I also see some references to users table. Do I need to perform any other exports in order to fully transfer and upgrade my database to a new server with a more recent version?

How do I import database data to a new host that runs a newer version of MySQL without ssh access?

My current host for an old website has only MySQL 5.0 (serverVersion=10.2.12-MariaDB-log).

I want to move this website to a host that has either 5.5 or 5.6 or 5.7 MySQL (depending which server I move to).

But the only instructions I can find for updating database data from 5.0 to 5.6/5.7 are run from the command line, requiring ssh access that I do not have.
For example these are the best, clearest instructions I have found, but I cannot use them because, as AFAIK, I do not have ssh, nor do no fully understand the references ([he?] makes. (e.g. he says --no faults “for simplicity” but even if I had ssh, I don’t know if I should also use that flag or others.)

  • http://mysqlserverteam.com/upgrading-directly-from-mysql-5-0-to-5-7-using-an-in-place-upgrade/
  • https://mysqlserverteam.com/upgrading-directly-from-mysql-5-0-to-5-6-with-mysqldump/

I usually use MySQL Workbench to connect to remote databases, but when I connect to that old host via MySQL Workbench, a message pops up saying [Workbench] is not compatible with 5.0.
So for that host, I have either used MySQL Workbench anyway to make a backup (which probably probably means the backup is no good), or I use the host’s web-based tool (not my preference, but obviously better). I have also recently installed HeidiSQL because it seems to be compatible with 5.0 (I does not give a warning/error message anyway). So I have started making backups and minor data changes on that host using HeidiSQL.

The only reason I have continued to use the host running MySQL 5.0 is because I haven’t yet found instructions on how to migrate data for websites on that server, whether it’s via a hosting provider’s online database tool, MySQL Workbench, or HeidiSQL !
Everything I see is for for doing step-wise data upgrades using the command line, and/or for upgrading the database server itself.

I need a way to upgrade the data from 5.0 to 5.6 or 5.0 to 5.7, probably in 1 step, using a gui database connection tool, or some other independent method. I will not have access to any mySQL servers other than the server I’m migrating away from (5.0), and the server I am migrating to (5.5 or 5.6 or 5.7).

Does anyone know how to do this?

EDIT:

  • I usually choose “Export” from the gui to export and choose all tables, when I do a database backup. I assume this is the same as a “database dump” that I see referenced everywhere.
    Is this correct? If not, how do I generate a proper dump file?
  • What export “settings” should I use when the goal is to upgrade and migrate?
  • I also see some references to users table. Do I need to perform any other exports in order to fully transfer and upgrade my database to a new server with a more recent version?

Install OS X 10.9 on VMware Fusion on newer MacBook [on hold]

My MacBook Air came with macOS Sierra, and I know that I can’t install an older macOS on that (reference: How to install OS X 10.9 on a new Mac mini loaded with OS X 10.11), but I don’t know why I can’t even install it on VMware Fusion as VMware Fusion does show up OS X 10.9 as one of its Guest OS.

I want to install OS X 10.9 on VMWare Fusion but as I already said VMWare is not allowing me.

What I Tried and what happens:

I tried to boot with a DMG as well as a .app file of OS X Mavericks and it boots fine until I see a prohibited sign after some time and I can’t proceed further. Also, I tried running it on my machine by burning the file to a USB, but as my computer is a newer make, it does not allow Mavericks to boot.

So, are there any workarounds so that I can boot OS X Mavericks at least in VMWare Fusion?

Macports: A port is requesting an older version of clang – will a newer one work?

I’m attempting to install neovim. When I run sudo port install neovim, it proceeds to install clang-3.7. However, port rdeps neovim doesn’t show clang-3.7 as a dependency. So none of neovim’s recursive dependencies require clang-3.7, correct? What’s causing the install of clang-3.7?

I have clang-4.0 and clang-5.0 installed. Will these work?

I am running a chroot on chrome os and my Ubuntu version is 16.04.6. Can I update to a newer version?

I am on a Chromebook and am running a chroot. My Ubuntu version is 16.04.6 I want to upgrade to a newer version. Is this possible? If I look online, it says to open a program called update manager. For me, that program does not exist and when I type in the command to get that program, it says HTTP quit unexpectedly. Can anyone help?

Can I sign with two Code Signing certs to build reputation on the newer one?

I recently acquired a Microsoft Authenticode Code-signing certificate as a renewal of another one which will expire soon.

Obviously, the new certificate has no reputation attached to it, and will take some time and installs in order to be fully trusted.

My question is: If I sign an executable with both certificates, will the new one start building reputation?

I have already verified that the installer is trusted when it has both signatures.

Upgrade Magento vendor module(dependency|library) to a newer version

Magento uses multiple “external” dependencies|libraries for example one of them is dotmailer-magento2-extension. This specific module is at version 3.1.1 as it can be seen here vendor/dotmailer/dotmailer-magento2-extension/composer.json

Is there any way to upgrade such a dependency module|library to a newer version? For example to update dotmailer module to 3.1.2.

I’m not looking to update the dotmailer module in particular but for a general way to update magento dependencies like libraries or modules.

Create a list of user whose home directories have no files newer than 7 years

I have an old storage with hundreds of user home directories. I want to reclaim some disk space by deleting all “old” home dirs. It’s on a linux server, RHEL 6. I want to delete the entire home dir., but only if there are no files that have been create, modified, updated or accessed, in under 7 years. Does anyone have any idea how to build a script to do this?

Thankyou.

dkms failure because gcc version is newer than that used to compile kernel

I have a kernel module that was registered with dkms. When a recent upgrade bumped my kernel to 4.15.0-50 I started getting the below error from dkms. Apparently kernel 4.15.0-50 was compiled with gcc version 7.3.0, but part of the upgrade involved installing a new version of gcc (7.4.0), which is causing dkms to fail. gcc 7.3 is no longer available on my system. How do I install gcc 7.3 in addition to 7.4, or even downgrade 7.4 to 7.3?

DKMS make.log for nvidia-430.14 for kernel 4.15.0-50-generic (x86_64) Tue May 14 17:08:12 CDT 2019 make[1]: Entering directory '/usr/src/linux-headers-4.15.0-50-generic' Makefile:976: "Cannot use CONFIG_STACK_VALIDATION=y, please install libelf-dev, libelf-devel or elfutils-libelf-devel"   SYMLINK /var/lib/dkms/nvidia/430.14/build/nvidia/nv-kernel.o   SYMLINK /var/lib/dkms/nvidia/430.14/build/nvidia-modeset/nv-modeset-kernel.o  Compiler version check failed:  The major and minor number of the compiler used to compile the kernel:  gcc version 7.3.0 (Ubuntu 7.3.0-16ubuntu3)  does not match the compiler used here:  cc (Ubuntu 7.4.0-1ubuntu1~18.04) 7.4.0 Copyright (C) 2017 Free Software Foundation, Inc. This is free software; see the source for copying conditions.  There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.   It is recommended to set the CC environment variable to the compiler that was used to compile the kernel.  The compiler version check can be disabled by setting the IGNORE_CC_MISMATCH environment variable to "1". However, mixing compiler versions between the kernel and kernel modules can result in subtle bugs that are difficult to diagnose.  *** Failed CC version check. Bailing out! ***  /var/lib/dkms/nvidia/430.14/build/Kbuild:182: recipe for target 'cc_version_check' failed make[2]: *** [cc_version_check] Error 1 make[2]: *** Waiting for unfinished jobs.... Makefile:1552: recipe for target '_module_/var/lib/dkms/nvidia/430.14/build' failed make[1]: *** [_module_/var/lib/dkms/nvidia/430.14/build] Error 2 make[1]: Leaving directory '/usr/src/linux-headers-4.15.0-50-generic' Makefile:81: recipe for target 'modules' failed make: *** [modules] Error 2