Move large MySql tables to a different HDD

MySql is by default installing everything in C:. As you need more space for C: or MySql you can move the whole database or only a few large files on a HDD with more free space. I choose to move only a few files because I intend to move some files on a removable external HDD, that can be accessed only when the external HDD is present and use MySql as it is without external HDD.
Step 1. Find what files are huge and need to be moved
mysql-sort-tables
2 of the files have more than 10 GB
The location of the tables on your disk can be found in the registry or in MySql Benchmark at {Management}{Server Status} as described in [1]
2. Save your database using MySql Benchmark {Management}{Data Export}{… Folder} in order to have individual access to tables in the dumped folder (change the dump folder on the empty HDD, also)
3. Rename actual table names with old at the end (we will truncate / delete them at the end if the new tables are OK)
ALTER TABLE `searchengineresults` RENAME TO `searchengineresults_old` ;
4. Update the create table sql file created at dumping your database, by including the DATA DIRECTORY parameter as described in [2]
CREATE TABLE `searchengineresults` ….. DATA DIRECTORY=’d:/mysql/tables’;
(you have to edit huge 7 GB text files – this a challenge – let me find a simple way
I am now editing a 1 Gb file with TextPad)
For files larger than 1 GB use the TableSpace solution from [2]
5. Run the updated sql from MySql Workbench
run-sql-script
6. Wait for the script completion (table creation and row import)
Check how the new table is growing in size during the script
mysql-growing file
Operation succeeded – see image
mysql-operation-ok
7. Deal with very large tables with a different method – classic method – why id did not work
Rename old table
Create new table using
Insert old data into new table with the instruction
insert into searchenginedetails
select * from searchenginedetails_old
It did not work because I run it from MySql Workbench who gave the warning “Timeout error at connection with mysqld server”
Then I did not receive the server from MySql Server and the resulted table was corrupted
select count(*) from searchenginedetails –> resulted in null or zero

8.
9
10
11.
12. Deal with very large tables with a different method (use copy TABLE SPACE method) – see [2]

(if you find empty spaces in the article it means that I am writing it now – just comment what you need from me right now 🙂 )

These are the files and tables of brianai.com – Artificial Intelligence for 200.000 personal images, all local. Try the app at BrianAI on our Exquisite View shop

Biography
[1] Move all database
[2] Move only one table

How to sell your images

Here are some sites where Brian AI can help you organize and upload images, for sale. See the examples below with images uploaded by me using Brian AI

dreamstime_portofolioDreamstime

getty_images_istock_portofolio-800Getty Images and iStock

picfair_portofolioPicFair

adobe_fotolia_portofolio-800Adobe & Fotolia

123rf-800123RF

See upload and organize instructions on User Manual of Brian AI. Try the application for free for 30 days !

Enjoy and a lot of sales !

Dorin

How to use Facebook posts, videos or photos in WordPress posts or HTML pages

Make a Facebook picture public on WordPress or Html page
Documentation
Link to How to use Artificial Intelligence to scan, find, organize, generate tags, publish on Facebook and much more
Article from Facebook
Article from a developer

Test
And the winner is IFrame from browser link ! See the instructions bellow

IFrame from browser link

1. Select the photo in Facebook to have it on the left part of the screen and on the right the tags and comments
Check that your photo is public (World icon not Lock icon)
2. copy the browser address and go to Facebook developer link
3. Paste the link into the “URL of the post” field
4. Enjoy the Facebook preview of your gorgeous picture
5. select GetCode and then IFrame tab
6. Copy and use the code as described there
7. Enjoy !

Second place is Embed code generated by Facebook page

1. Select the photo in Facebook to have it on the left part of the screen and on the right the tags and comments
Check that your photo is public shared (World icon not Lock icon)
2. Choose menus {Options}{Embed}
3. Copy and use the code as described there

What about a Facebook Album ?

1. Select the album in Facebook
Check that your album is public (World icon not Lock icon)
2. Go to {Settings}{Get Link}, copy the address and go to Facebook developer link
3. Paste the link into the “URL of the post” field
4. Enjoy the Facebook preview of your gorgeous album
5. select GetCode and then IFrame tab
6. Copy and use the code as described there
7. Enjoy !

Learn more
Link to How to use Artificial Intelligence to scan, find, organize, generate tags, publish on Facebook and much more

——————————————-
Bellow are tests that do not work – I have to see them on different browsers and devices, so just ignore them

Div from browser link

#skyline, #city, #UrbanArea, #daytime, #MetropolitanArea, #downtown, #skyscraper, #sky, #cityscape, #metropolis, #pier,…

Posted by Dorin Ionescu on Friday, January 12, 2018

Div HTML code from copy image address

or IFrame HTML code

The five classes of Artificial Intelligence algorithms

The symbolists focus more on philosophy, logic and psychology and view learning as inverse of deduction.
The connectionists focus on physics and neurosciences and believe in the reverse engineering of the brain.
The evolutionaries, as the name suggests, draw their conclusions on the basis of genetics and evolutionary biology,
whereas the Bayesians focus on statistics and probabilistic inference.
And the analogizers depend on extrapolating the similarity judgements by focusing more on psychology and mathematical optimization.

read more here
Master-algorithm-the-solution-to-our-machine-learning-problems

book review
Book

secret document link How to use Artificial Intelligence

Facebook 360

secret document link How to use Artificial Intelligence


Facebook added support for 360 degrees images and videos.
I will start to add some here to test the system

See content from inside Facebook on this link Christ the Redeemer

Christ the Redeemer (Portuguese: Cristo Redentor) is an Art Deco statue of Jesus Christ in Rio de Janeiro, Brazil, created by French sculptor Paul Landowski and built by the Brazilian engineer Heitor da Silva Costa, in collaboration with the French engineer Albert Caquot.
Romanian sculptor Gheorghe Leonida fashioned the face.
The statue is 30 metres (98 ft) tall, not including its 8-metre (26 ft) pedestal,
and its arms stretch 28 metres (92 ft) wide
read more here Christ the Redeemer on Wikipedia

360 image view with WordPress (temporarry error – I will start testing another plugin)

The 360 viewer is WP-VR-view – Photo Sphere and 360 video by Tumanov Alexander
normal photo

SAMSUNG
SAMSUNG

Google Drive 360 movie iframe – let’s see how it works

read 18.000 more insights on the following mobile apps or on your Apple Watch

png_Download_on_the_App_Store_Badge_US-UK_135x40 Get it on Google Play Get it on Windows 10

FIA Formula E, Enel electric car is ready for Buenos Aires, Argentina

enel_car_30_20170202_103702._90jpg

Enel has teamed up with the FIA Formula E Championship – the world’s first fully-electric racing series – after announcing an agreement to become the championship’s Official Power Partner. The announcement was made at an event held today at the MAXXI Contemporary Art and Architecture museum in Rome.
See video of the car here

Formula E is partnering with global energy leader Enel to promote the advancement of the championship’s power technology infrastructure.

Formula E CEO Alejandro Agag said: “We are delighted to welcome Enel as the Official Power Partner of Formula E. The solutions that they will put in place to allow all of our events to be carbon neutral reinforces our belief that business, sport and entertainment can be run in a fully sustainable way. This is a very exciting new venture and I look forward to witnessing the developments in sustainable power delivery that comes as a result of this partnership.”

Francesco Starace, CEO and General Manager of the Enel Group, said: “We are delighted to be partnering with the Formula E team to lend our expertise in accelerating the digitisation of their energy management infrastructure and powering them through our renewable energy generation technologies. Enel and Formula E are natural partners, as we both embrace the exciting opportunities in electric mobility, smart cities and the clean energy revolution. We are now joining forces to continue with our pioneering work in the field of technological innovation for the vehicles of the future.”

Enel will work with Formula E to optimise its clean energy generation, distribution and management, showcasing its advanced energy solutions. The partnership gets the green light at the upcoming Berlin ePrix, which takes place on May 21st, and will run through the following two seasons, with the possibility to extend the agreement beyond the 2017/18 season.

Read the whole article here
FIA Article on fiaformulae.com

Read more on secret code “Energy” on the following mobile apps

png_Download_on_the_App_Store_Badge_US-UK_135x40 Get it on Google Play Get it on Windows 10

Apple Watch Science & Technology app for iPhone, Android and Windows 10 (smartphone, laptop, desktop and hub)


#AppleWatch my Videnda science & technology news app just received a sweet review on @Appszoom !
Check it out: AppsZoom link

And another one at WatchAware. Hope it will work well on #iPhone8 and #AppleWatch3. Read it here WatchAware Article

Apple Watch photos
musca Simulator Screen Shot Dec 13, 2016, 8.27.39 AMSimulator Screen Shot Dec 13, 2016, 8.25.54 AM

Simulator Screen Shot Dec 13, 2016, 8.28.02 AMSimulator Screen Shot Dec 13, 2016, 8.28.46 AM

default50 Simulator Screen Shot Dec 13, 2016, 12.06.41 AM

details Simulator Screen Shot Dec 13, 2016, 12.08.29 AM

iPhone photos
full width Simulator Screen Shot Dec 13, 2016, 12.10.26 AM

Read 18.000 more articles using the following apps

png_Download_on_the_App_Store_Badge_US-UK_135x40 Get it on Google Play Get it on Windows 10

Virtual Reality videos are the way we will work or enjoy things in the future

Create Virtual Reality videos

VR Glasses
VR Glasses

The Jump Camera rig consists of 16 camera modules in a circular array. The size of the rig and the arrangement of the cameras are optimized to work with the Jump assembler.
Jump assembles 360 videos that allow you to experience a scene in every direction. Perfect stereo ensures that near things look near, far things look far.
3D alignment approach creates a beautiful, seamless panorama, so you won’t see borders where cameras are spliced together.

Jump camera rig
Jump camera rig
Assembled 3D videos are super high resolution – the equivalent of five 4k TVs playing at once.

See the main article and other info on secret key “360” on the following mobile apps

png_Download_on_the_App_Store_Badge_US-UK_135x40 Get it on Google Play

Enjoy !

Dorin

3D printing a 400 sqm villa

3D printing a 400 sqm villa – The house has been build using 3D printing equipment, from concrete, resulting a beautiful 400 square meters villa

3D printed villa
3D printed villa

3D printing house is a new technology in the field of construction, using a 3D model of reinforced concrete on-site printing equipment. The company was founded in 1989, and is located in Tongzhou District of Beijing, is one of powerful enterprises in the industry. See the videos of the construction phases and other articles on the main link on secret key “3D” on the following mobile apps

png_Download_on_the_App_Store_Badge_US-UK_135x40 Get it on Google Play

Enjoy !

Dorin

Apps for iPhone, iPad and Android Smartphones

png_Download_on_the_App_Store_Badge_US-UK_135x40 Get it on Google Play

ipad_large_landscape_1000

Read more on key “artificial intelligence” using the following apps for Android, iPhone or similar

png_Download_on_the_App_Store_Badge_US-UK_135x40 Get it on Google Play

Why do we need to learn about science and technology ?
If you know the answer write something for this contest Link to Contest
1 billion people do not know how to enter Google.com or Freelancer.com or Videnda.eu because they do not know the answer to the question. You are here, so you know the answer. When the revelation will come out from deep inside your brain, do not forget to drop it on the contest 🙂

Why should you spend your time “for free”, to learn science and technology or work for contest that you may not win ?
Here are 2 arguments
1. If you think trying is risky and learning is just time consuming, wait until you will receive the bill for not trying or for not learning (adapted from Jim Rohn)
2. See on this link what prizes can achieve for us XPrize past and new prizes
3. Science is unlimited. The only limit science has are our temporary limitations. Potential is infinite
Robots and Artificial Intelligence (AI) will have souls like we have. They do not have it at this moment because we, the humans, are still limited in understanding the soul and create a software from what we learned.
If robots and AI are the future than the following scenario is aplicable
“Humans will be able to replicate flowers and AI in the Universe, AI will replicate Humans
Do not despair, do not worry, we are all interconnected. We are the bad guys that you may see in AI, but even we do not kill all the lions (except for stupid hunters that want to make a buck)
But no matter of how many Hitlers are born from within us we still keep species alive, against nature or our earlier mistakes, so will AI. We do not kill all the monkey because they do not know how to take the power from us, even if some politicians acts like monkeys. We will not be a direct threat for AI but an indirect, human build by (a rocket is programmed to follow unfriendly airplanes and destroy them – if such a machine will loose the capacity to detect friendliness, we will all die by our own weapon)”

Did you meet your resolutions for 2016 ?
What did you learn until now ? What could you learn ? What you must learn ?
You still have time to learn what you promised yourself you would
“Only if you decide now and never leave the place of your decision without taking action toward your goals” Tony Robbins

iPhone – iPad (iOS Apple) iPhone – iPad (iOS Apple)
Android smartphones (Google) Android smartphones (Google)

png_Download_on_the_App_Store_Badge_US-UK_135x40 Get it on Google Play

Enjoy !

Dorin

Bitnami