ホームページ制作|札幌
北海道札幌市北区北6条西6丁目2-1朝日プラザ偕楽園506号室
営業時間 7:00-24:00 TEL/FAX 011-768-8116
代表:グレン チャールズ ロウ
ただいま19人がオンライン中:ゲスト12人7 検索ボート,

Category Archives: how-to

How to Export and Import Database in phpMyAdmin

INSTRUCTIONS

Method 1 – phpMyAdmin

Export

  1. Select your database from the list on the left.
  2. Click on “Export” from the top set of tabs.
  3. Select the tables from the list that you would like to back up. If you want to back up the entire database, click “Select All.”
  4. Make sure both the “Structure” and “Data” boxes are selected on the right. They should be, by default.In the Structure section, check the “Add DROP TABLE / DROP VIEW” box if you want this export to be able to replace existing tables of the same name. If you want to merge this backup with another database, do not select this.
  5. Check the “Save as file” box. Also select a compression option (such as “gzipped”) if you want to compress the backup before downloading it from the server.
  6. Click the “Go” button, and, at the prompt, save the file to your local computer.

Import

  1. Make sure the database you need has already been created. If it has not, please first create the database:

    CAUTION:

    If you import a backup file to a database that already has content, it will replace the existing content.

  2. In phpMyAdmin, select your database from the list on the left.
  3. Click on “Import” from the top set of tabs.
  4. Click on the “Browse” button next to “Location of the text file.”
  5. Browse to your local SQL file and click “Open.” If it is a zipped file, please unzip the file first.
  6. Click the “Go” button at the bottom. Wait while your database imports. Depending on the size, this can take a few minutes.

    You should get a message like this:Import has been successfully finished, X queries executed.

    If you instead receive an error, please try the command line method below.

Does Illustrator get stuck while scrolling through fonts? Here’s a fix!

Does Illustrator get stuck while scrolling through fonts? Here’s a fix!

Enable Missing Glyph Protection - CS6 -  Illustrator gets stuck when scrolling through fonts

For the longest time if I select some text and start scrolling through fonts to find one that worked well, it would get stuck on certain fonts while scrolling and had to manually skip a couple fonts so I can keep browsing through only the get stuck by another. I decided that I’ve had enough of that and decided to search for a solution.

Surprisingly, I couldn’t find many pages discussing this issue but I eventually found a solution.

Here is the fix:

  1. Go to Edit > Preferences (or Ctrl/Cmd + K)
  1. Select Type
  1. Uncheck Enable Missing Glyph Protection

Ever since unchecking that setting, AI hasn’t gotten stuck once. Hope this helps someone.

Source: http://www.tommywhite.com/news/illustrator-gets-stuck-or-jumps-to-the-bottom-of-the-list-when-scrolling-through-fonts

Delete all iPhone bookmarks quickly

Delete all iPhone bookmarks quickly

The easiest way is to go to Settings -> then search for iCloud. Disable syncing of Safari. You will be asked what do you want to do with the synced data on your device. Simply select to delete it. Afterwards, there will be no bookmarks via your Safari browser app on the device.

Is Safari opening too slowly because of all your bookmarks?

If it is, change the folder that your iPhone shows first to speed up your phone.

Choose a folder that has a smaller number of bookmarks to show up first by default.

How to Export and Import Database in phpMyAdmin

INSTRUCTIONS

Method 1 – phpMyAdmin

Export

  1. Select your database from the list on the left.
  2. Click on “Export” from the top set of tabs.
  3. Select the tables from the list that you would like to back up. If you want to back up the entire database, click “Select All.”
  4. Make sure both the “Structure” and “Data” boxes are selected on the right. They should be, by default.In the Structure section, check the “Add DROP TABLE / DROP VIEW” box if you want this export to be able to replace existing tables of the same name. If you want to merge this backup with another database, do not select this.
  5. Check the “Save as file” box. Also select a compression option (such as “gzipped”) if you want to compress the backup before downloading it from the server.
  6. Click the “Go” button, and, at the prompt, save the file to your local computer.

Import

  1. Make sure the database you need has already been created. If it has not, please first create the database:

    CAUTION:

    If you import a backup file to a database that already has content, it will replace the existing content.

  2. In phpMyAdmin, select your database from the list on the left.
  3. Click on “Import” from the top set of tabs.
  4. Click on the “Browse” button next to “Location of the text file.”
  5. Browse to your local SQL file and click “Open.” If it is a zipped file, please unzip the file first.
  6. Click the “Go” button at the bottom. Wait while your database imports. Depending on the size, this can take a few minutes.

    You should get a message like this:Import has been successfully finished, X queries executed.

    If you instead receive an error, please try the command line method below.

Replace difficult to read font in Google Chrome

How to swap font in Chrome of it is difficult to read:

Load the Google CHrome app named Styler:

https://chrome.google.com/webstore/detail/styler/bogdgcfoocbajfkjjolkmcdcnnellpkb?utm_source=chrome-app-launcher-info-dialog

Then go to the page with the bad font.

Click on the Styler S icon on the top right of Chrome.

Copy and paste the code below with the font you want to change:

Helvetica Neue for example:

@font-face { font-family: ‘helvetica neue’; src: local(‘Arial’); }

All done.

Solving Rubik’s Cube in 20 Moves

Learn how to solve the Rubik cube in 20 or less moves here.

There are a lot of things you can learn about the Rubik’s Cube aside from actually solving the puzzle below. Here is an infographic to help you learn a little bit more, courtesy of Reddit.

It was in Budapest in 1974 when Erno Rubik first invented the Rubik’s Cube. Did you also know that there’s a movement in art called Rubikubism? Allegedly, to enter you must have medical conditions such as Cubist’s Thumb and/or Rubik’s Wrist before you can join. People who spend too much time playing with the cube sometimes develop these types of conditions.


Adobe gets around the 64-bit TWAIN scanner problem by leaving the 32-bit version of Photoshop on the installation DVD

scanner_faceAdobe released a 64 and 32 bit version of Photoshop CS6 but forgot to mention it wouldn’t work with most scanners out of the box. By leaving in the 32-bit version of Photoshop on the installation DVDs, Adobe said to many users that they would have to use the 32-bit version for now instead, as many scanner makers can’t update their drivers… The main problem with this wasn’t that the scanner didn’t work any more it was that this information wasn’t written up anywhere which really annoyed a lot of users again. The TWAIN driver that used to be pre-installed can only be loaded into the 32-bit version and you will have to load it from the DVDs you were given for now.

I wonder if Adobe with ever bring back those useful thumbnail previews that had on the standard Windows desktop instead of their blue icons.

Skype: Download the full version of the installer

Skype includes hidden gamesIf you are having trouble installing Skype, you can download the full version of the installer here:

Click here to download

What is Skype?

Skype is software that enables the world’s conversations. Millions of individuals and businesses use it to make free video and voice one-to-one and group calls, send instant messages and share files with other people on Skype. You can use this software on whatever works best for you – on your mobile, computer or tablet.

Skype is free to download and easy to use.

If you pay a little, you can do more – like call phones and send SMS. You can pay as you go or buy a subscription, whatever works for you. And in the world of business, this means you can bring your entire ecosystem of workers, partners and customers together to get things done.

Try Skype today and start adding your friends, family and colleagues. They won’t be hard to find; hundreds of millions of people are already using it to do all sorts of things together.

Here are some pros and cons of Skype:

Pros:

It is one of the cheapest VoIP services available, and it offers subscriptions with unlimited minutes.
It is easy to install and it works without much configuration.
Users of Skype can enjoy unlimited number of chats and videoconferencing when they contact people who are also on Skype.
Since this is Internet based, you can chat with families abroad any time you want. This can be used 24 hours a day.
It can be used for business presentations because this allows screen sharing.
Calls from one Skype user to another are free, wherever they are in the world.

Cons:

Skype is not free, and it requires the internet for it to work.
It’s light on features, lacking call return, call blocking and most important, 911 calling ability.
It can affect real world interaction.
Skype does not offer language translation.
Skype is still lacking in business tools.
It can act as a server for other people’s calls, passing their voice data through your computer en route to its destination. Some users have reported that their bandwidth and CPU usage has increased dramatically when running Skype (even when not making calls).
Skype is a popular application and is sure to attract hackers’ attention.
The quality of sound with VoIP isn’t as good as on a landline or mobile.
If you are using a webcam the sound quality deteriorates.
There is frequently background noise and the service can be subject to drop-outs.
History automatically retrieved after deleted once even.

Adobe CS6 (Creative Suite) Master Collection Installing in the Wrong Language

adobe-cs6-cc-cs7-master-collection-language-settings-how-to-install-in-englishIf you have downloaded the Adobe CC or CS6 Master Collection trial and it isn’t installing in English, then it might be a Region and Language settings problem.

Here are the steps to fixing the problem, if this is the case:

1. Open the Control Panel.

2. Open Region and Language settings.

3. On the Region and Language window click on the Formats tab. Then change the format to English.

Eg. Format: English (United States)

4. Try installing the Adobe CS6 Master Collection trial again.

It should now install in English ^^

Use the System File Checker tool to troubleshoot missing or corrupted system files on Windows Vista or on Windows 7

Use the System File Checker tool (SFC.exe) to determine which file is causing the issue, and then replace the file.

To do this, follow these steps:

  1. Open an elevated command prompt. To do this, click Start, click All Programs, click Accessories, right-click Command Prompt, and then click Run as administrator. If you are prompted for an administrator password or for a confirmation, type the password, or click Allow.
  2. At the command prompt, type the following command, and then press ENTER:
    sfc /scannow

    The sfc /scannow command scans all protected system files and replaces incorrect versions with correct Microsoft versions.

A4JP.COM DESIGN

Copyright © 2019