In the next edition of our Before the Home Lab series we’ll look our first hypervisor, VMware ESXi, and how to install it in a homelab setting. Full Disclosure: My homelab is fully ESXi / vSphere, with no vCenter deployments.
What is ESXi?
ESXi or vSphere is VMware’s solution for virtualized systems. ESXi actually ships the free version with everything you may need to upgrade so upgrading is just popping in a new commercial or enterprise key. The latest version as of this posting is 6.7u1 or version 6.7 update 1 and licensing is done based on the major version so purchasing a key for version 6.0 or using VMUG would net you a valid key for ESXi that will work for all versions under 6.
A word on VMUG, otherwise known as VMUG Advantage with EVAL. This program allows you access to a list of useful products including:
VMware vSphere ESXi Enterprise Plus with Operations Management (6 CPU licenses)
VMware Fusion Pro 10
VMware Workstation Pro 14
If you have no idea what those are, a quick refresher is that vCenter is the management solution for multiple separate vSphere (ESXi) hypervisors, VMware Fusion and Workstation are virtualization solutions so you can run virtual machines on your local Mac and Windows system respectively. Workstation Pro has some neat features like uploading a VM to ESXi which makes creating a new machine locally and moving it to your server worth it. The $200/yr VMUG cost gets you a 1 year license to these products and others. I have not personally used Fusion, but people near me who use Mac products tell me it is an okay way to virtualize stuff.
How to Install ESXi
The first step to getting ESXi is to download it so head over to the download link and make a totally unnecessary account that you will surely forget by the next time you need to log back in.
Once you’ve logged in, you can finally download the free trial. Since we’re virtualizing, we’ll get the ISO with VMware tools and don’t forget to copy down your trial key.
In a physical deployment, you’d make a bootable disk out of this ISO on a flash drive and then install it on your hardware on an SD card or USB drive. Since this is a virtual deployment, we’re going to move this ISO file directly into the main datastore on my ESXi test bed. We’ll look over the web-ui after we install.
Let’s create the VM, remembering our original requirements.
For reference, we added 50GB of thin-provisioned hard drive and an ISO file for ESXi. Under CPU, we clicked ‘expose hardware assisted virtualization’ so ESXi can do it’s thing.
We can then start the VM and see the installer.
ESXi Starting Services.
ESXI reminds you to ensure your systems are in the compatibility guide.
Accept the magical agreement where you sell your soul.
Select a disk to install on.
Try not to forget this password.
Smash that F11 to start the installation.
And away we go.
Once you complete your install, ESXi will reboot and you should remove your installation media.
Those of you still playing at home will notice this is not a management interface. The new web-ui shipping with version 6.5 and higher can be accessed using http://your-ip/ui. Just click Advanced and past the security warning on a secure virtualization environment.
Now you can login with your password.
As the final thing you should do before starting, you should head over to Manage > Licensing and add your trial key. The regular installation key expires after 60 days while the free trial keys are free forever (with limitations).
After putting the key in, you can click Assign license to verify and the second time to assign the key.
Homework: Try installing the vCenter virtual appliance and evaluating vCenter. Hint: You can add an OVA to your setup by going to Host > Create/Register VM > Deploy OVA
Up next, a walkthrough for installing Hyper-V in a home lab setting.
Unity XT reported that both power supplies in the systems are not supported:
SP logs (Can be found in the Unity support data collection tar file under spX\EMC\backend\log_shared\EMCSystemLogFile.log — where spX is the primary SP):
B 09/05/19 18:55:14.119 Bus9 Enc0 PowA 1678006 [ERROR] System: Power Supply is Faulted (Unsupported ).
B 09/05/19 18:55:14.131 Bus9 Enc0 PowB 1678006 [ERROR] System: Power Supply is Faulted (Unsupported ).
A 09/05/19 19:06:18.834 Bus9 Enc0 PowA 1678006 [ERROR] System: Power Supply is Faulted (Unsupported ).
A 09/05/19 19:06:18.847 Bus9 Enc0 PowB 1678006 [ERROR] System: Power Supply is Faulted (Unsupported ).
Fbecli logs (Can be found in the Unity support data collection tar file under spX\cmd_outputs\fbecli_exe_ccollectall.txt — where spX contains the log for that SP):
SP B [Active SP] PEER SP: PRESENT
HW Cache Status: FAILED Reason: PS
DPE-SCORP 990 (Bus 99, Pos 0) -OK
EnclFaultLedReason: PS Fault PS A B
FLT (0102) FLT (0102)
Bus 99 Enclosure 0 PS Slot 0 Info:
Associated SP : SP_A(0)
State : OK
SubState : NO FAULT
Logical Fault : YES PS uniqueId : 0xB004F00(ATLAS 1980W High GEN2 OTS PSU (Acbel))
PS Supported : NO Low Line Input : YES
Bus 99 Enclosure 0 PS Slot 1 Info:
Associated SP : SP_B(1)
State : OK
SubState : NO FAULT
Logical Fault : YES PS uniqueId : 0xB004F00(ATLAS 1980W High GEN2 OTS PSU (Acbel))
PS Supported : NO Low Line Input : YES
## speclcli getAll ##
__ SPA PS0 Status __
Input Voltage : 116 Volts
__ SPB PS0 Status __
Input Voltage : 117 Volts
Currently Unity XT 480/680 supports 2 types of power supply models:
ATLAS: PN: 071-000-750-01
POSEIDON: PN: 071-000-760-03
If the Unity PS is ATLAS, a hi-line power supply, it does not support low line AC voltage such as from a wall power outlet (110V) and will cause the alert.
To fix the issue:
Change the AC input from 110V to 220V
Replace the PS model from ATLAS to POSEIDON
NOTE: Power Supplies may be replaced while the array is running. Replace one power supply at a time. Alerts will be generated during the swap. Alerts like “Power Supply Intermix” can be ignored/acknowledged.
If you are connecting the Poseidon Power supply to a wall outlet, order the correct cable to go from the power supply to a wall outlet using the DOC-394778 link below.
The Poseidon power supply is only used for Low Line power for the Unity 480(F) and Unity 680(F) where supply voltages to the storage array are in the 100-120V range. To connect the power supply to a wall outlet, select the C19 cable with the specific countries wall outlet connector. The connector on the other end of the cable is dependent on the specific country wall plug type.
NOTE: Please order these Country Specific Cords directly from MyQuotes and provide the EMC Model number.
EXAMPLE: The United States uses EMC Model number: C19-PWR-12 Part Number: 038-004-848
Description: C19 PWR CORD W/ NEMA 5-15P PLUG, 125V 15A
The different cable types are available in the ordering path and are added by default when ordering a new system for Low Line power.
They are also available in the “Add-on Hardware” section in both the new and upgrade MyQuotes ordering paths.
According to Unity XT hardware guide, the power requirements are below. When using low line power input, ATLAS PS only supplies 1050W which doesn’t meet the 1450W power requirement to DPE but POSEIDON fully supplies the capacity.
Power specifications per Unity model
Model High line Low line
Unity 480/480F 1800 W 1450 W
Unity 680/680F 1800 W 1450 W
Unity 880/880F 1800 W 1800 W (Step-up transformer required)
ATLAS Specification: GEN2 CFF 1800W HL 1050W LL PSU AC
POSEIDON Specification: GEN2 CFF 1450W LL 2100W HL AC DC PSU AC
Scenario 1: When we try to remove host access for snapshots, error occurs:
“Host access cannot be modified for the following Consistency Group LUNs as they are snapshots. Go to the Consistency Group page to modify host access for the snapshots. And default snapshot’s host access cannot be removed in GUI either”
When checked, there was no Consistency Group listed.
Scenario 2:Customer was not able to remove the non-attached host access from the snapshots on the GUI for the existing CG,
Example of the CG snapshot access:
After removing the host access from the snapshots, The hosts are seen as not-attached snapshot hosts under snapshot access.(Noticed in scenarios where the snapshots are attached to VEAM backup)
Run the below command to remove the host access from the snapshots.
uemcli -u admin -securePassword /stor/prov/luns/lun -id <LUN_id_value> set -snapHosts “”
uemcli -u admin -securePassword /stor/prov/vmware/vmfs -id <vmfs_id_value> set -snapHosts “”
uemcli -u admin -securePassword /stor/prov/luns/group -id <value> set -snapHosts “”
Below are the commands to get the ID values. ( Select the ID value for which you are trying to remove the snapshot host access)
uemcli /stor/prov/luns/lun show -detail
uemcli /stor/prov/vmware/vmfs show -detail
uemcli /stor/prov/luns/group show -detail
The above commands will remove all the hosts access from the snapshot access only.
Please make sure to verify the same, incorrect modification will impact access of other hosts attached to snapshots.
Hate being the one in the corner of the room while everyone else is enjoying themselves on the dance floor? Have an event coming up that will require you to step out to the beat? If a little crisis of confidence or some uncertainty about how to move is keeping you from joining the fun, don’t worry. If you take the time to master a few basic moves, you can learn to dance freestyle, do a romantic slow dance, or impress your fellow guests on the dance floor at the next family wedding.
wikiHow Video: How to Dance
Bob your head to the rhythm. Start by trying to understand the beat of the music. If it helps, try counting along, clicking or clapping your hands to the beat. Once you’ve figured out the rhythm, start moving to it by bobbing your head.
Once you get your head moving, it will make it easier for you to get the rest of your body going.
To find the beat, try listening to the drums or the bass. These instruments usually carry the rhythm of the song.
Tip: To get used to finding the rhythm of a song, practice by listening to songs with a clear and pronounced beat. For example, try clapping and moving along to the beat of a song like “Juke Joint” by Johnnie Taylor.
Shift your weight from one foot to another. When you have a good sense of the beat and rhythm, you can start incorporating some simple footwork. Start by shifting all of your weight to one foot. You can lift the other foot slightly off the ground to make sure all your weight is off of it. Shift back and forth in time to the music.
At every other count (preferably 1 to 3), shift your weight completely to the other foot. You can also shift your weight at every count, but starting out slowly will help you get comfortable before you begin dancing fast.
Keep your legs loose and bend your knees slightly. There should be just a little bit of “bounce” to your weight shifts, and a subtle bounce (in place) on the counts when you aren’t shifting your weight as well.
Move your feet to the beat. Once you’re comfortable shifting your weight to the rhythm, begin moving your feet. Right before you shift your weight to a foot, move it slightly, even just 1–2 inches (2.5–5.1 cm) from where it was before. When you move your foot, keep it fairly close to the ground.
Stay on the balls of your feet so you can move and bounce more easily.
If you’re dancing with someone else, be sure to move around in a way that accommodates your partner without stepping on them.
Add some hip action. When you put your weight on a foot, move your hips (and your body) slightly in the direction of that foot. If you shift your weight onto your right foot, for example, move your hips to the right. You can twist your body slightly to add a little more movement.
For example, when you move to the right, put your right shoulder forward a little and your left shoulder back. Do the opposite when you move to the left.
Incorporate some arm movements. If you’re uncomfortable, the tendency is to keep your arms close or to let them hang limp. Instead, move your arms around. Keep your hands open or in very loose fists. You can put your arms in the air or bend them at the elbows and hold them at your sides, like when you’re running. Whatever you do, don’t get stuck on just one move; keep switching it up! You can also try one of these moves:
Roll the dice. Make a loose fist and shake your arm and hand as though you are shaking a pair of dice for a roll. After a few shakes, “roll” the dice. Don’t overuse this move to the point that it becomes comical.
Mow the lawn. Bend forward and grasp the starter of an imaginary lawn mower with one hand, then pull your hand back as though you’re pulling on the starter. Once you get it going, you can take a few steps while you mow the lawn.
Swing an air lasso. Grab an imaginary lasso and swing it above your head as though you’re about to rope a cow. Shift your weight to the foot opposite your “lasso hand” and thrust your hips in that direction.
Pump your fist. Make a fist and then make a pumping motion overhead in a celebratory fashion.
Find your own style. Follow your natural impulses when you’re dancing freestyle. It’s easy to feel like you’re only good at one move, but the more you feel the rhythm, the more natural your movements will become. Listening to subtleties in music will also help to train your body to move. Most importantly, be creative! Creating your own dance moves is easy with confidence and an understanding of your body.
Experiment with different moves, positions, and speeds while you dance.
Don’t be afraid to make up your own moves. Free style is all about improvisation and individual expression.
Slow Dancing with a Partner
Get into position with your partner. Stand face-to-face with your partner and get into a basic partner position. If you are leading, put your right hand on your partner’s shoulder blade and interlock your left hand with their right hand, with your hands positioned in the shape of a pair of Cs. Your partner will put their left hand on your right shoulder.
You can keep your clasped hands held as high as eye level or as low as waist level, depending on your preference. Just keep them relaxed, with a comfortable bend at the elbow, and don’t raise your partner’s shoulder.
Leave about 3–6 inches (7.6–15.2 cm) of space between yourself and your partner.
Make sure you and your partner agree on who is leading before you begin!
Tip: Slow dances are typically performed by a man and a woman, with the man leading. However, there’s no need to stick to this traditional arrangement. Pair up with a partner of any gender you like, and decide with your partner who should lead based on confidence, height, or whatever other factors you choose.
Step to the left with your left foot. Once you’re ready to start dancing, move your left foot out to the side in a smooth, gliding motion. Your partner will mirror you with their right foot. This is the first part of the basic “step-touch” slow dance move.
If your partner is leading, let them initiate the first step, but try to move with them as smoothly as possible.
Try to time your steps with the beat of the music. You may find it helpful to count along with the music in your head.
Bring your right foot over to meet your left. After taking the first step with your left foot, slide your right foot over so that it touches your left. Your partner should mirror this movement.
Try not to bounce or dip as you bring your feet together. Aim for a smooth, gliding movement.
Repeat your foot movements in the opposite direction. Once you’ve brought your feet together, step to the right with your right foot. Then, bring your left foot over to meet your right. Continue this pattern throughout the rest of the dance.
Alternatively, you can do 2 steps to the left and then 2 steps to the right.
Use your hands to steer your partner if you want to move around. If you’d like to move around the dance floor, use your hands to gently push or pull your partner in the direction you’d like to go. After touching your feet together, push with one hand and pull with the other at the same time that you step out on the next beat.
For example, if you’re stepping left but want to pivot to the right, start by bringing your right foot to meet your left. Then, push your partner’s right hand with your left hand while gently pulling on their shoulder with your right hand, and step to the left at the same time.
Dancing at a Wedding
Learn the Chicken Dance for lighthearted numbers. The Chicken Dance is a staple of many wedding receptions. It’s easy to do because there are just 3 basic moves, and you change them in time with the music. This is also a very low-pressure dance—no one cares if you mess up. To do the chicken dance:
Raise your arms to shoulder level and line your thumbs up with your index fingers to create a shape that resembles a chicken’s beak. Move your thumbs up and down to simulate a chicken clucking.
Then, ball up your hands and tuck your fists under your arms as though you have wings. Flap your wings up and down in time to the music.
With your wings still in place, continue flapping but now stick out your backside, bend your knees and wiggle your bottom down toward the floor.
Repeat these moves over and over until the song ends.
Master the hora for Jewish weddings. The hora is danced at many traditional Jewish wedding receptions to the song “Hava Nagila” or other traditional Jewish songs. The hora simply involves dancing in what’s known as a “grapevine” pattern:
Step the left foot across to the right. Let the right foot follow. Step the left foot behind the right. Follow again with the right.
This dance is performed in a circle with dancers either holding hands or throwing their arms over one another’s shoulders.
The tempo of this dance is typically fast. Sometimes the music starts slowly, and the band speeds up the tempo as the song goes along.
Did you know? At Orthodox Jewish weddings, men and women dance the hora separately. At more liberal weddings, male and female guests mingle and do the dance together.
Use basic slow dance moves for the Dollar Dance. At some weddings, the guests line up and pay a dollar (or more) to dance with the wedding couple. You can use basic slow dance moves for this dance, but it’s really not about the moves; it’s about having a few moments with the bride or groom to express your happiness for the couple and compliment the wedding ceremony and reception.
In some cases, men dance with the bride, and women dance with the groom. Other times, both men and women dance with the bride.
Holding on and simply swaying in place is perfectly acceptable if it makes it easier to have a personal conversation.
Getting All the Right Moves
Take a dance class to learn some basic moves. There are dance classes for every style of dancing from hip-hop to ballet, break dancing to salsa. Search online for the classes in your area. Whatever style of dance you’re interested in, you could probably benefit from a ballroom dancing class as the steps of many other dance styles have their roots in some ballroom basics.
When you are being taught a routine, look at what the teacher is doing. Try to copy it exactly. If it doesn’t work, watch the teacher again and look for the little things they do that make it easier.
Go ahead and ask your instructor for tips. Experienced instructors have worked with hundreds of students and have ideas that can help you overcome whatever it is you’re finding to be difficult.
Even a few hours of class time can help you learn the basics and build your confidence.
Join a flash mob to boost your confidence. A flash mob is a spontaneous public performance—usually a dance—that appears seemingly out of nowhere and then disappears just as quickly. While these dance performances may seem spontaneous, the truth is that they’re usually fairly well rehearsed in advance. You can find flash mobs online, join them for a several-week rehearsal period as the group learns a dance, and then perform with the mob in public.
Some flash mobs put videos online with instructions for learning and rehearsing the planned dance.
Flash mobs welcome people of all skill levels; their focus is on having fun and creating a joyful scene, so the more people who participate, the better.
You’ll also learn some great dance moves and connect with other people who enjoy dancing.
Watch dancing on TV to find inspiration. Dancing is a wildly popular activity, and you can get plenty of exposure to it just by watching TV. Try tuning in to reality television dance competition shows. Focusing on the steps might be a bit challenging. Instead, pay attention to how loose the dancers are, how much confidence they display, and how much fun it looks like they’re having on the dance floor.
Popular current dance shows include Dancing with the Stars and So You Think You Can Dance.
Rent a classic dance movie to get new ideas. There are so many dance movies to choose from. See as many as you can or pick and choose those that speak to your particular interests. For example:
Check out Dirty Dancing or Shall We Dance to watch 2 dance novices develop confidence and grace and learn to perform with pizzazz.
Watch Footloose or Flashdance to see the power of dance as a form of defiance against uptight authority figures and personal circumstances.
Rent anything starring Fred Astaire and Ginger Rogers to be inspired by the grace and elegance of these famous dance partners.
Watch Stormy Weather to see the Nicholas Brothers push the limits of tap dancing.
Participate in a dance competition to hone your skills. Ballroom dancing competitions, officially known as DanceSport events, are held all over the world. Check online for a competition near you. Joining a dance competition can help you set specific goals for yourself and encourage you to build your skills.
Check out websites such as the International Grand Ball, United States Dance Championships, and the Access Dance Network to name just a few.
Tip: If you’re not confident enough to join a competition yet, attending competitions as a spectator can help inspire you and give you an idea of what to expect.
Dressing to Dance
Put on comfortable dance shoes. Choose a well-fitting shoe with a flexible, thin sole for the dance floor. Stay away from platform shoes, since that thick sole and heel make it difficult to feel the floor. Be sure, too, that your feet feel secure in your shoes. Backless sandals are best left at home. Do not wear sneakers or other shoes with rubbery or sticky soles for ballroom style dancing, since these can make it hard to move your feet smoothly across the floor.
Different styles of dance call for different types of shoes, so do some research about what’s needed for your preferred style. For example, sneakers are great for hip hop or freestyle dancing, while heels are ideal for Latin dance styles.
Be prepared for the heat. If you tend to perspire, choose garments made of natural fibers. Tank tops and halter tops can look great, but sweaty or clammy skin could be a turn off if a partner asks you to dance. Drop a pack of moist towelettes and a travel-size powder in your pocket so you can freshen up when needed.
If you’ll be dancing with a partner, avoid wearing slippery materials, like silk. Your partner may have a hard time holding onto you if their hands get sweaty.
Tip: Consider bringing a spare top or a change of clothes in case you really work up a sweat.
Wear clothes that allow you to move. Tight satin might look and feel great when you’re not moving much, but it could inhibit your moves on the dance floor. Even worse, one wrong move could leave you with an embarrassing rip. Choose clothes that are either loose enough to let you move or stretchy enough to move with your body. Select a top with sleeves that don’t restrict your arm movement—you should be able to lift your arms above your head.
Try on your outfit at home to be sure you can dance with ease.
To avoid wardrobe malfunctions, make sure your clothing fits securely and won’t slip out of place if you really get moving!
How to Move Content From One WordPress Site to Another
Moving your WordPress site to another location can be a stressful and fiddly experience, not helped by the fact you can’t just simply move your files and database. No, that’s just not how WordPress works.
Fortunately, WordPress has a handy “Import” and “Export” tool built in. But unfortunately, it’ll only suit some basic requirements and you need to improvise a little to achieve other effects.
In this article, I’ll show you step-by-step how to migrate your WordPress installation’s content to a new place.
Let’s get cracking!
Before We Start: Back Up Your Website
Some WordPress installations or server setups may present you with unique challenges on migrating content. Although this article will deal with an additional unique eventuality (namely that you only want to transfer a part of your WordPress installation’s content), there’s no guarantee that the steps detailed here will unfailingly work for every setup.
It goes without saying that you’re solely responsible for your site, even when following this guide to the letter; there’s some database work involved depending on what you want to do, and if you accidentally delete a huge chunk of your site, that’s down to you. Basically, be careful with this!
For the purposes of this post, I’ve created two separate localhost installations of WordPress to provide you with pictures of each step. You might like to try moving your content to a test site to check it works.
To that end, I’d recommend making a backup of your entire site at this point. Of course, you do that regularly, don’t you? (If not, you definitely should be. Get to it.)
If you want to do this manually, remember to include both your database and site files (primarily because this includes your website’s Uploads folder).
Backing Up Files
You can create and download a ZIP of your site files via FTP. How to do this varies per FTP client but is generally fairly obvious. Make sure you download and securely store your backup compressed file – just as with any backup.
Backing Up Your Database
Login to your phpMyAdmin account and select the database in which WordPress is installed.
Select Export from the top menu. For most people, “Quick” options will be adequate. However, if you have tables other than the WordPress installation you want to back up in the same database, click Custom to select the tables you want to back up; all other options should remain untouched. Finally, click Go to download your database backup file (.sql format).
Hopefully, those backups won’t be needed, but it’s always advisable before embarking upon such work. If the site to which you’re migrating content already has content, make sure you back up that one too.
With precautions out of the way, let’s get to work!
Changing Your WordPress Installation’s URL? Transferring a Whole Site
If you’re just looking to change your website to a new URL or otherwise want to transfer absolutely everything from one installation to another, the good news is that you’ve picked the easy option. WordPress’s own import and export tools will work perfectly for you so no need to do anything too complicated under the hood.
Here’s how to transfer all your WordPress content – pages, images and files, posts and everything else – to a new installation.
Incidentally, it is probably easiest to create a new installation on your new server (or even the new location within a server) and import/export than to change your files’ configurations. However, if you’d rather do it that way, the WordPress Codex can advise. Your installation should be up-to-date with the latest WordPress version so it won’t be a problem, but if it’s not, upgrade your old installation first. If you really can’t update for some reason – such as keeping a plugin that doesn’t work with new versions – your new installation can be an old version. This is far from recommended because many old versions of WordPress have critical security flaws.
1. Export From Your Old Installation
Go to your WordPress dashboard and select the Export item from the Tools section.
Because you’re exporting everything, it’s easy: keep the All content option selected and hit Download Export File.
An XML file will be created. Keep it in a safe place and go across to the installation to which you’re migrating.
2. Install the Importer
On the new WordPress installation, go once again to Tools, but this time select Import.
You will be shown a list of importers, from which you should select the WordPress option.
Click Install Now and wait for the importer plugin to download and install.
If it all works, you can click Activate Plugin & Run Importer on the next screen.
At this point, you’re all ready to import and the XML file you generated earlier comes into play.
3. Upload Your Content
Click Choose File on the screen that follows and select the XML file you created on the old site.
Next, click Upload file and import.
4. Assign the Content
You’ll be given an option to assign content to existing users on the new site (if you have an account on both, you can assign your old posts to your new account), or create new users either with their old usernames or with a new one you select. This ensures all the content is attributed to an author account that exists on the new site.
If you have any images or files to move to the new site, make absolutely sure that you tick Download and import file attachments– it’s not selected by default.
Hit the Submit button and you’re done! The page may take a little longer than usual to load because it’s creating all the new rows on the database, but it will get through it. Just wait patiently for it to be processed and all of your content should be imported onto the new site ready for its life there.
Partial Content Movement
So that’s the easy bit out of the way. However, if you’re looking to export only some of your content, I’m afraid to say that WordPress’s tools probably won’t cater for your needs on their own.
Selecting All content is the only way to export your attachments (files that appear under the Media section). Therefore, if you want to transfer specific parts of the content and your images, you’ll either need to move everything across then delete it (time consuming for larger sites) or poke around in your files and database – which I shall show you how to do now.
The exporting and changing SQL that I’m about to show you will be demonstrated for moving attachments, but you can also use a similar methodology to transfer the whole database across. This is useful if you want to transfer everything but your XML file is too large to upload through the importer.
1. Select the Content You Want to Export
Venture once more to the Tools > Export screen to begin with.
Once you’ve selected which content you’d like to export, click Download Export File as before. If there are multiple selections you’d like to make (eg. two authors’ posts in a date range, or someone’s posts and all pages), it’s entirely possible to go back and create multiple export files for each selection.
2. Import as Before
After you have all the WXR XML files you want, go to the new site and install the WordPress Importer as previously shown. You can upload your files (one at a time) as before and they’ll install the specific posts/pages/other content onto the site.
However, this is not the end, because you’ll notice that you still don’t have any attachments (eg. uploaded images) on your installation quite yet.
3. Duplicate Media Files
Go to your old installation’s FTP client and find the /wp-content/uploads/ folder. I’m using Windows 10’s File Explorer as my FTP client, but most should be able to compress files and download them.
Download the .ZIP file you generate and upload it to your new site’s FTP (or cut and paste it if you can access both sites through your FTP client).
You can then extract all the files from the compressed folder into the Uploads directory.
Unfortunately, that’s not the end of it; while your files are in the right place, your WordPress installation won’t know about them because the attachment details haven’t yet been copied across from the database.
4. Export Attachment Posts
Head over to your old site’s phpMyAdmin database and find the wp_posts table (replace wp_ with your prefix as necessary).
At this point, you need to find the attachment posts (those are the media posts) so paste in the following SQL (changing the table name to have the right prefix if necessary) and hit Go.
`post_type` = "attachment"
Scroll to the bottom of the query results and check Show all so all attachment posts are showing. Once all rows are displayed, choose Check All then click Export.
At this point, things get a bit more complicated, but stay with me and follow the steps carefully and you should be fine.
Choose Custom to show all possible settings.
Scroll down to the Format-specific Options section.
Leave everything else as it is and click Go.
5. Edit Your SQL
This step is necessary if your new installation has a different database prefix to the one from which you’ve just downloaded your SQL export file.
Edit the .sql file using a text editor such as Notepad++, finding and replacing the old prefix with the new prefix.
If your prefixes are the same (eg. both tables are wp_posts), that’s fine and you can ignore this step.
6. Import Attachment Posts
Go to your new database and find wp_posts (or equivalent); click Import.
Click Choose File – make sure you click, don’t drag it in, as this means it won’t be uploaded in the right place – and select the exported SQL file.
Leave all other options as they are and execute the query by hitting Go. You’ll see a success message once it’s finished and all your attachments will now be visible under Media – although there’s a further step before your images will start showing up properly.
7. Export Post Meta
Similar to the previous database work, this time find your old installation’s wp_postmeta table and select the Export tab.
Select Custom settings again and choose data rather than structure and data, just as before.
This time, also locate the Data Creation Options heading and select REPLACE as the function to use when dumping data.
Once again, click Go to create and download your SQL file.
8. Edit Your SQL
Again, you need to change the prefixes in your SQL file if the new database prefix will be different. You should also find all references to your old URL and replace them with the new one.
9. Import Post Meta
Go to your new wp_postmeta (or other applicable prefix) table and, exactly as before, import your edited SQL file into the new installation.
Your media library is now complete once more, ready to fit back into your transferred content (finally).
If you’ve got through all that, well done – it’s a bit of a roundabout method just to transfer some images across with specific posts.
Of course, there are still catches with this: if you only want to migrate some of the images, you need to go through and pick out the folders (hopefully you want them by date or it would take forever) more carefully when uploading. You could also run into trouble with duplicate primary keys transferring wp_posts if you already had posts on the new installation.
Clearly, to make the Import/Export process more intuitive – rather than requiring such creative thinking with the databases behind the CMS – some work will need to be completed for a future WordPress release. While we wait, however, if you do need to move some of your content, this should work for you – it’s well worth the time!
If you’ve got any more ideas and methods for moving across parts of a WordPress installation with all the content in tow, we’d love you to share it with us in the comments. Likewise, let us know if you’re having any issues with these methods and we can try to give you a hand.
Having a power bank with you can be extremely convenient, especially when you are away from a power outlet. Power banks ensure that your devices won’t run out of charge. However, in order to charge your devices on the go, your power bank itself has to be charged. Power banks can easily be charged with a laptop or wall socket. Once your power bank is fully charged, you can unplug it and use it again.
Plugging in Your Power Bank
Check the LED lights to see when your power bank needs charging. While a power bank can be charged at any time, unnecessary charging may decrease its lifespan. Most power banks have 4 LED lights on the side. The lights will shut off as the battery diminishes. Wait to charge your power bank until only 1 or 2 lights are on.
Plug your power bank into a wall outlet if possible. Your power bank should have come with a USB cord and wall adapter. Plug the larger end of the USB cord into the wall adapter. Then, plug the smaller end into your power adapter. Leave the power bank to charge.
Plug your power bank into a computer or laptop as an alternative. A computer or laptop can also be used to charge a power bank. Connect the smaller end of the USB cord into the power bank. Then, connect the larger end of the USB cord into your computer or laptop’s USB drive.
It will take longer to charge a power bank on a computer than it would with a wall charger.
Letting the Power Bank Charge
Check your manufacturer’s instructions for an estimate of charging time. You should not leave your power bank charging longer than necessary. Your manufacturer’s instructions should let you know roughly how long it will take to charge. Most power banks charge within 1-2 hours.
Disconnect the charger as soon as it’s fully charged. Check the charger periodically as it’s plugged in. As soon as all the LED lights are on, unplug the charger. Your power bank’s lights may also blink on and off until it’s fully charged, at which point it the light will stay lit.
If your LED lights are not working, unplug the charger after the estimated charging time has passed.
Check to make sure the power bank charged properly. After charging your power bank, connect one of your electronic devices to the bank using a USB cord. If the power bank charged correctly, the device should begin charging.
If the device didn’t charge, try plugging it into a different outlet. If your power bank still won’t charge, it may be broken. Contact the manufacturer to see if it can be fixed.
Use a wall socket in most cases. In general, wall sockets will charge a power bank faster than a computer or laptop. Stick to charging your power bank through the wall unless you only have a laptop or computer available.
Use only the cable that came with the power bank to charge it. The power bank should come with a charging cable with a USB port and a wall adapter. Avoid using a different charging cable that was not designed for the power bank.
Avoid overcharging your power bank. Make sure not to leave your power bank plugged in for too long. Charging the bank for hours on end can cause its battery life to decrease. Only charge your power bank as long as necessary for the LED lights to stop blinking.
Charge your electronic device and power bank simultaneously. While your power bank is charging, plug in any electronic devices you typically charge with your power bank into a wall socket. Charging devices eats up a power bank’s battery. If you charge your electronic devices at the same time, you won’t have to use the power bank as quickly after it charges. This will increase its battery life.