Insert a short description about yourself here, and possibly a small photo, or comment this line out.

Calendar

March 2007
M T W T F S S
« Nov   Jun »
 1234
567891011
12131415161718
19202122232425
262728293031  

March 27, 2007

http://www.tamba2.org.uk/wordpress/restore/

Категория: Uncategorized — technotes @ 1:11 pm
WordPress 2.x.x uses a cache file. You MUST delete the cache or this will not appear to have worked.
Delete everything in the /wp-content/cache directory before you upload the new files and before you do the following restore.

Where are you restoring to ?

Restoring could involve changing the backup file you have. To guard against damage, make a copy of it on your computer now.

If you have moved to a new host and you have a new database, do Step ONE

If you are restoring into the same database, do Step TWO

Step ONE

All you need to do is create the database, nothing else. Remember that your wp-config.php file must have all the correct details in too or when you try your blog you will get an error. Go to Step THREE.

Step TWO

Restoring into your existing database means that you must first delete everything in there. PLEASE be sure that this really is a necessary step, and check that you really do have a full backup of your WordPress tables.
There is no ‘undo’ function !!
You need to DROP all WordPress tables in your database to make room for the restore.

restore image

You will then see

restore image

Click Yes IF YOU ARE SURE.
Your database is now empty. Go to Step THREE

Step THREE

The actual import.

Click the name of your database, then the SQL tab

restore image

There are 2 ways to get your data in:

restore image

A - You can open the .sql file and paste the contents into the window OR
B - You can use that button to locate the file on your computer and upload it.
READ THIS ! If your .sql file is less than about 3meg in size, you will probably be fine with either method.
If your .sql file is larger, you can try the upload but you may get timeout errors. This is NOT the fault of WordPress - it is a host setting. If you have your own server you can change the settings. If you cannot alter that, and you get timeouts, you will have to do the following;

  1. Open the .sql file in a text editor. Do NOT use a word-processor, or Dreamweaver or GoLive unless you REALLY know what you are doing - on a Windows machine WordPad is okay.
  2. You will see something similar to this at the top:

    – phpMyAdmin SQL Dump
    – version 2.6.1-pl2
    – http://www.phpmyadmin.net

    – Host: localhost
    – Generation Time: Jun 24, 2005 at 05:14 PM
    – Server version: 4.0.24
    – PHP Version: 4.3.11

    – Database: `tamba2_data`

    CREATE DATABASE `tamba2_data`;
    USE tamba2_data;

    – ——————————————————–

    Ignore all that. You do not need it.

  3. Everything else in that file needs copying and pasting into the SQL window. You highlight some text, copy it, paste it into the SQL window, click Go and after the Success message, you do it again with the next chunk of text.
  4. It can take a while, and you need to be careful that you miss no lines out.

restore image

If after moving everything you get a blank page when looking at your blog, check your themes. A faulty theme file will cause this blank page. Try changing themes or uploading a new theme then changing to it.

If this does not help, check that all the WordPress files are present and are the correct size. Download a new set of WordPress files if needed and use your ftp client to do this.

From experience, there are a number of things which can mess things up when restoring and while nothing is fatal to your data it’s very complicated to describe here.
If you run into trouble, make a post to the Support Forums. If you email me directly for help with this, I will NOT assist unless I have full access to complete the import - it is too long and complex to do any other way, including by IM.
• • •

March 20, 2007

RS232 Cables, Wiring and Pinouts

Категория: Uncategorized — technotes @ 7:31 pm

RS232 Cables, Wiring and Pinouts

RS232 Wiring Stuff

http://www.zytrax.com/tech/layer_1/cables/tech_rs232.htm#db9

RS232 standards are defined by EIA/TIA (Electronic Industries Alliance /Telecommunications Industry Association). RS232 defines both the physical and electrical characteristics of the interface. RS232 is practically identical to ITU V.24 (signal description and names) and V.28 (electrical). RS232 is an Active LOW voltage driven interface and operates at +12V to -12V where:

Signal = 0 (LOW) > +3.0V

Signal = 1 (HIGH) < -3.0V

Notes:

  1. Signal voltages in the range >-3.0V to +3.0V is regarded as the ‘dead area’ and allows for absorption of noise. For more on the use of signals and other heavy stuff.
  2. The power level on RS232 pins is defined by TIA in terms of short circuit protection to be 100mA. Most RS232 drivers will provide lower short circuit protection (especially for laptops). A max of 50mA PER PIN may be available but the data sheet for the specific interface/chip should be consulted before commiting to externally powered designs.
  3. We received an email recently pointing out some issues with NULL modem cables. The pinouts shown below will gnerally work. However there are many permutations of signal sets that can be used by either end of a connection and they may not be SYMMETRIC. One end may expect something (a signal) that the other end cannot generate. This typically happens with CTS/RTS (and perhaps DCD) and DTR/DSR. If you suspect this is the case then unfortunately you need to UNDERSTAND the interface and may have to SPOOF certain signals. Our signal primer page may help you. Finally if you are having serious problems, splash out on a light box or some other device that will show you which signals are being activated.
  4. Watch the terms DTE (Data Terminal Equipment - a terminal or PC) and DCE (Data communications Equipment - for example, a modem) the meaning and use of certain pins may differ. All the diagrams below define the interface from the DTE perspective. An RS232 interface has a female and male connector, the male connector has the bits sticking out!!
  5. The terms Data Carrier Detect (DCD) and Received Line Signal Detect (RLSD) are one and the same. We use DCD throughout ‘cos we think it’s more common.
  6. Like most folks we use the term DB9 which is widely - but erroneously - used to describe a 9-pin serial connector. We got an email pointing out the error of our ways. So, if you want to amaze your friends over the dinner table you can read more here and use the technically correct terms in the future. While we get away with it most of the time (with common or garden PCs), sometimes it is essential to know EXACTLY what connector type you are talking about.
  7. RS-232-E is normally defined to be used with a DB25 connector, but does have a 26 pin (a much smaller connector) alternate . We suggest that if you come across one of these that you do the decent thing - use an expletive. Alternatively, with your luck, you could consider buying a lottery ticket.
  8. We have received a number of emails recently asking how to wire DB9’s using cat5(e) cable. We guess there is a lot of LAN cable lying around these days so folks naturally want to use it. We have added a null modem only section to cover this wiring. There is absolutely no standard to cover this form of wiring. This section is simply offered as one of many possible ways to do it.

Contents

RS232 on DB25 Pinout (RS-232C)

RS232 on DB9 Pinout (EIA/TIA - 574)

RS232 on RJ45 (RS-232D EIA/TIA-561)

RS232 DB25 NULL Modem Pinout

RS232 DB9 NULL Modem Pinout

RS232 DB9 NULL Modem Pinout using Cat5(e)

RS232 DB9 to DB25 Pinout

RS232 DB9 to DB25 NULL Modem Pinout

EIA/TIA RS-530-A (DB25 using RS-422, 423 and 485)

V.35 on a DB25

DBx - Designations for D type sub-miniature connectors

T1/E1 Pinout (RJ-48C)

RS232 on DB25 (RS-232C)

Signal/pin primer

Note: This is NOT the same as the DB25 Parallel port on a PC.

Pin No. Name Notes/Description Pin No. Name Notes/Description
1 - Protective/shielded ground 14 STD Secondary Transmit Data
2 TD Transmit Data (a.k.a TxD, Tx) 15 DB Transmit Clock (a.k.a TCLK, TxCLK)
3 RD Receive Data (a.k.a RxD, Rx) 16 SRD Secondary Receive Data
4 RTS Request To Send 17 DD Receive Clock (a.k.a. RCLK)
5 CTS Clear To Send 18 LL Local Loopback
6 DSR Data Set Ready 19 SRTS Secondary Request to Send
7 SGND Signal Ground 20 DTR Data Terminal Ready
8 CD Carrier Detect (a.k.a DCD) 21 RL/SQ Signal Quality Detector/Remote loopback
9 - Reserved for data set testing 22 RI Ring Indicator (DCE raises when incoming call detected used for auto answer applications)
10 - Reserved for data set testing 23 CH/CI Signal Rate selector
11 - Unassigned 24 DA Auxiliary Clock (a.k.a. ACLK)
12 SDCD Secondary Carrier Detect 25 - Unassigned
13 SCTS Secondary Clear to send - - -

NOTE: Leave all pins not specified above unconnected.

db25

view - looking into male connector

up icon

RS232 on DB9 (EIA/TIA 574)

Signal/pin primer

Pin No. Name Notes/Description
1 DCD Data Carrier Detect
2 RD Receive Data (a.k.a RxD, Rx)
3 TD Transmit Data (a.k.a TxD, Tx)
4 DTR Data Terminal Ready
5 SGND Ground
6 DSR Data Set Ready
7 RTS Request To Send
8 CTS Clear To Send
9 RI Ring Indicator

db9

View - looking into male connector

up icon

RS232 on RJ45 (RS-232D)

More properly EIA/TIA - 561. Use when connecting to or from a serial port with a 8 position Modular Jack (RJ45). If you are cross-connecting from a DB9 or a DB25 use the signal names to cross connect the appropriate connections.

Signal/pin primer

Pin No. Name Notes/Description
1 DSR/RI Data set Ready/ring indicator
2 DCD Data Carrier Detect
3 DTR Data Terminal Ready
4 SGND Signal Ground
5 RD Receive Data
6 TD Transmit Data
7 CTS Clear to Send
8 RTS Request to Send

Note: Pin 1 is a multi-function pin sharing with DSR (Data Set Ready) and RI (Ring Indicator). This means it is impossible to differentiate between a incoming ring signal and when the modem has finally connected and synched up. With local (null modem connections) or if the modem is run in auto-answer mode this is not normally a problem. If used with a modem and the DTE (the computer end) wants to control the connection the problem is more real. DSR would normally indicate the ‘connected and synched-up’ state following DTR from the DTE. DCD will indicate that a carrier has been received but does not indicate synchronization of both ends. In most cases however CTS (Clear To Send) in response to RTS (Request To Send) will not normally be returned until an end-to-end connection is available.

RJ45

RJ45 Male Connector Pin Numbering

up icon

RS232 DB25 NULL Modem Pinout

Use when connecting two systems (e.g. PCs) via their DB25 interfaces without a modem (i.e. back-to-back). See the full signal names in the DB25 sections.

If this pinout does not work for you then you could try our Signal/pin primer because you may need to SPOOF connections.

Note: This DB25 is NOT the same as the DB25 Parallel port on a PC which is defined here.

DB25 Signal DB25 Signal
3 RD 2 TD
2 TD 3 RD
20 DTR 6,8 DSR, DCD
6,8 DSR, DCD 20 DTR
4 RTS 5 CTS
5 CTS 4 RTS
7 SGND 7 SGND
22 RI 22 RI

db25

View - looking into male connector

NOTE:

  1. Leave all pins not specified above unconnected.
  2. We have received email suggesting that the above pinout looks like DTR from one side is driving into DSR/DCD on the other side - not normally a healthy situation. The emails miss the point that since both ends are DTEs NEITHER should be attempting to drive the DSR/DCD signals. They are essentialy RX only signals on both sides.

up icon

RS232 DB9 NULL Modem Pinout

Use when connecting two systems (e.g. PCs) via their DB9 interfaces without a modem (i.e. back-to-back). See the full signal names in the DB9 section.

If this pinout does not work for you then you could try our Signal/pin primer because you may need to SPOOF connections.

DB9 Signal DB9 Signal
2 RD 3 TD
3 TD 2 RD
4 DTR 6,1 DSR, DCD
6,1 DSR, DCD 4 DTR
7 RTS 8 CTS
8 CTS 7 RTS
5 SGND 5 SGND
9 RI 9 RI

db9

View - looking into male connector

NOTE:

  1. We have received email suggesting that the above pinout looks like DTR from one side is driving into DSR/DCD on the other side - not normally a healthy situation. The emails miss the point that since both ends are DTEs NEITHER should be attempting to drive the DSR/DCD signals. They are essentialy RX only signals on both sides.

up icon

RS232 DB9 NULL Modem Pinout on CAT5

This is in response to a number of recent emails asking how to wire both ends of a DB9 connection using cat5(e) cable. This must not be confused with DB9 to RJ45 (RS232D). We have shown a null modem (back-to-back PCs) only configuration. And if you want to use cat5(e) with a real modem (a DB25 connector)? Our advice - don’t.

Warning:. There is, as far as we know, no standard to cover the use of cat5(e) (8 conductor) wiring when used with two DB9 connectors. Any such wiring scheme is therefore non-standard - that includes the wiring scheme below. Specifically this means that both ends of the cable must be wired in the same way and that no assumptions can be made about how the other end is wired. You will have to manually inspect both ends of the connection. Damage can result from mis-matched wiring.

A DB9 clearly has 9 connections and a cat5(e) cable has 8 conductors. RS232D has chosen to use Pin 1 as a multi-function pin (DSR/RI) to provide maximum flexibility with modems - in particular it allows for DCD which is a meaningful signal from a modem but not we suggest from a peer PC. We have chosen to use a minor variation on the normal DB9 Null modem pinout above - specifically we have allowed for RI which could be used from a peer PC to commence a transmission sequence. The actual colors are unimportant but the suggested configuration is one way to provide the shortest use of the adjacent (twisted) pairs.

If this pinout does not work for you then you could try our Signal/pin primer because you may need to SPOOF connections.

PC1 Peer PC2 Peer
2 RD Brown 3 TD Blue
3 TD Blue 2 RD Brown
4 DTR Green 6,1 DSR, DCD Brown-white
6,1 DSR, DCD Brown-white 4 DTR Green
7 RTS Blue-white 8 CTS Green-white
8 CTS Green-white 7 RTS Blue-white
5 SGND Orange 5 SGND Orange
9 RI Orange-white 9 RI Orange-white

db9

View - looking into male connector

NOTE:

  1. We have received email suggesting that the above pinout looks like DTR from one side is driving into DSR/DCD on the other side - not normally a healthy situation. The emails miss the point that since both ends are DTEs NEITHER should be attempting to drive the DSR/DCD signals. They are essentialy RX only signals on both sides.

up icon

RS232 DB9 to DB25 Pinout

Use when connecting a DB9 (e.g. a PC) to a DB25 (e.g. a modem) interface. See the full signal names in the DB9 and DB25 section.

Signal/pin primer

DB9 Signal DB25
1 DCD 8
2 RD 3
3 TD 2
4 DTR 20
5 SGND 7
6 DSR 6
7 RTS 4
8 CTS 5
9 RI 22

db9

View - looking into male connector

db25

View - looking into male connector

NOTE: Leave all pins not specified above unconnected.

up icon

RS232 DB9 to DB25 NULL Modem Pinout

Use when connecting two systems (e.g. PCs) when one has a DB9 interface and the other a DB25 interface without a modem (i.e. back-to-back). See the full signal names in the DB9 and DB25 sections.

Signal/pin primer

DB9 Signal DB25 Signal
2 RD 2 TD
3 TD 3 RD
4 DTR 6,8 DSR, DCD
6,1 DSR, DCD 20 DTR
7 RTS 5 CTS
8 CTS 4 RTS
5 SGND 7 SGND
9 RI 22 RI

db9

View - looking into male connector

db25

View - looking into male connector

NOTE: Leave all pins not specified above unconnected.

up icon

EIA/TIA RS-530-A (DB25)

RS 530-A defines the pinout when using either balanced RS-422 (and RS-485) or unbalanced RS-423 electrical interfaces using a DB25 connector. By using a DB25 connector RS-530 is now frequently used to replace many older standards which defined hideously huge connectors such V.35. (used a whopping 35 pin connector) and RS-449 (used a pretty serious 37 pin connector).

V.35 on DB25 (RS-530-A)

The original V.35 specification defined use of balanced signals over a huge 37 pin connector. V.35 itself has been obsolete for years (replaced with V.10 and V.11) though the termin is frequently used. Most modern systems that call themselves V.35 use a DB25 connector which has more modest dimensions. The A (+) and B (-) below refer to each signal pair used in balanced serial interfaces. When used with RS-423 (unbalanced) the B (-) are tied to a common ground. Signals marked U under Bal/Ubal are not balanced since they typically change very infrequently (for example once per session) and therefore do not affect TX/RX performance sensitivity - hence speed. BEWARE: RS-530 (without the A suffix) is an earlier standard and is wired differently. This is the 530-A pinout spec.

Signal/pin primer

Pin No. Name Bal/Ubal Notes/Description

NOTES:

  • Leave any pins not specified above unconnected.
  • In balanced mode signals with the same name are the paired set, for example, pins 2 and 14 are both named BA and form the Transmit Data pair. Each signal of the pair is either a high (A+) or low (B-)
  • When used with RS-485 in half-duplex, multi-dropped environments a simple three signal arrangements is frequently used - one pin is used as a GND and RX/TX is alternately switched onto a balanced pair of wires which can be either the BA (TX) or BB (RX) pair.

db25

View - looking into male connector

up icon

DB - Designations for D-subminiature Connectors

This lists the designations for DB connectors (supplied by Rob Recny - Thanks). Any errors in this list are ours not Rob’s.

  • A - 15-pin 2-row joystick connector.
  • B - 25-pin 2-row serial or parallel connector - also 44-pin high-density 3-row.
  • C - 37-pin connector - sometimes found on multi-port serial or data acquisition boards.
  • D - 50-pin connector - a little longer than C, but three rows using the same pins as the 2-row connectors.
  • E - 9-pin 2-row serial - also 3-row VGA.

So a DB9 is more properly a DE-9P. Isn’t knowledge a wonderful thing!

up icon

T1/E1 Pinout (RJ-48C)

T1/E1 wiring may use either a RJ45, DB15 or BNC connectors. The pinout shown uses RJ45 connectors and is known as USOC RJ-48C. T1 is a North America (primarily) digital service providing 1.544 Mbps. E1 is a European/Rest of World standard providing digital service at 2.048 Mbps. CATegory 5(e) cabling is used to provide balanced pairs. The color coding for Cat 5(e) cabling may be 568A or 568B.

RJ45 Pin Signal Notes
1 RX1  
2 RX2  
3 FGND Ground/Shield
4 TX1  
5 TX2  
6 FGND Ground/Shield
7 NC Unused
8 NC Unused

NOTE: NC = Not connected.

• • •
Powered by: WordPress • Шаблон: ADMIN-BG